Skip to main content

Full Change Log

v3.0.3

Fixes

  • Fix #952 Run only selected text

v3.0.2

Fixes

  • Fix #952 Only run selected test

v3.0.1

Updates

  • Added query information button to traces
  • Updated Query History icons
  • #949 Exposed Theme/Mode setting in Options
  • Added MPARAMETER keyword to syntax highlighting

Fixes

  • Fixed #891 Error exporting to static Excel file
  • Fixed #889 crash when dragging trace windows
  • Fixed #886 incorrect link to tutorial in Getting Started dialog
  • Fixed #894 Define and Expand sometimes producing incorrect output
  • Fixed #924 username blank in All Queries trace
  • Fixed #930 increased default code completion window width
  • Fixed #931 automatically select all text in find/replace dialog
  • Fixed #906 improved waterfall layout in Server Timings
  • Fixed setting focus in the editor when changing tabs
  • Fixed file icon registration
  • Improved error handling around shutdown operations
  • Added extra hotkey validation rules
  • Fixed #916 added retry logic to all clipboard operations
  • Improved Power BI filename detection for non-English cultures
  • Removed unused dependencies and reduced installer/portable file size

v3.0.0

New / Enhanced

  • New modern skin
  • Dark/Light Mode support
  • View As support
  • Benchmark can run with ViewAs to test RLS impact
  • All Queries can be enabled with other traces
  • Added simplified ribbon view

Updates

  • #826 added PowerPivot model detection timeout in options
  • Updating syntax highlighting to handle multi-line strings
  • Added highlighting of cache nodes in physical query plans
  • Improved state tracking for trace windows
  • Prevented interleaving of clearcache with query execution

Fixes

  • Fixed #764 error when running from cmd prompt
  • Fixed #799 error when opening querybuilder files from older versions
  • Fixed #812 FIPS compliant hash
  • Fixed #816 database dropdown too small
  • Fixed #838 added support for custom datetime formats when exporting to xlsx
  • Fixed #841 allowed for loading of performance data where component information was missing

v2.17.3

Fixes

  • Fixed #760 not loading the model metadata when the regional settings for the current machine uses something other than a period (.) for the decimal separator
  • Fixed a crash in the QueryBuilder when the model metadata has not loaded correctly

v2.17.2

2.17.2 fixes an issue where the automated build for 2.17.0 failed to sign the installer and includes the following updates from 2.17.0

New Features

  • Added Parameter support to Query Builder filters
  • Removing <pii> tags from xmSQL in Server Timings to improve readability
  • Fixing accuracy of Server Timings for queries with Batch events
  • Fixed #709 query builder queries are now captured in the query history
  • Fixed #747 the /f parameter can now open vpax files
  • Fixed #699 added extra information to the error message when the XMLA endpoint is not correctly enabled
  • improved caching of measure expressions

Fixes

  • Fixed #703 preventing a crash when entering a proxy password
  • Fixed #715 added DOUBLE data type to intellisense and syntax highlighting
  • Fixed #740 export to Excel failed on some machines
  • Fixed #755 saving parameters to XML was not correctly encoding special characters
  • Fixed #750 would crash on startup if the WMI information on the machine was corrupt
  • Fixed download link in Help - About screen

v2.16.2

Fixes

  • #662 Showing View Metrics Last Refreshed and Analysis Date in the local timezone
  • #659 When saving a file with the Query Builder open custom measure names were not saved
  • #663 Debug commas not handling lines with indented comments correctly
  • #664 Traces fail to start with a timeout error
  • #670 View Metrics - Last Refreshed date was incorrectly adjusting from UTC time

v2.16.1

Fixes

  • #657 Unable to open a new query tab either with a new connection or with a copied connection
  • #658 passing the database name on the command line
  • #647 hidden objects not hidden correctly when show hidden objects option was turned off (this was partially fixed in 2.16.0 but should work in all scenarios now)

v2.16.0

New Features

  • Added "Preview Data" right-click option for tables and columns
  • #580 extended Parameter support to include data types other than text
  • Added "New Version" notification in the title bar
  • Updated xmSQL cleanup to also fix table names
  • added sponsor page to github https://github.com/sponsors/daxstudio
  • #612 supporting all of the /f /s /d command line parameters at the same time
  • Query Builder Improvements
    • Adding Auto-Generate to Query Builder
    • Clicking Edit Query from the Query Builder will now update any previously generated query text
    • #570 Adding ORDER BY support to the Query Builder
  • Custom Key-Bindings moved out of preview
  • #620 Adding Ctrl+W to select current word
  • #584 Extending Hover tooltip to work with Keywords
  • #636 Show PBIX filename in the database dropdown instead of database ID
  • #638 Adding encoding option when using Exporting Data to CSV files
  • #632 extending installer support for Windows ARM64
  • updating ADOMD / AMO references to 19.22

Preview Features

  • Debug Commas - moves commas in formated queries to the start of the line
  • Show XMLA Commands in All Queries trace - shows commands sent by other tools like SSDT and Tabular Editor

Fixes

  • #578 Analyze in Excel not working with PBI XMLA or AzureAS
  • #579 Server Timings Layout Tab not appearing
  • Improved error message when no query text is specified
  • #581 All Queries Trace against PowerPivot caused crash
  • Fixed a crash when attempting to add a display folder to the Query Builder
  • Fixed a crash when attempting to use the query builder against a model with an invalid calculation script
  • #592 datatypes not syntax highlighted and not in code completion
  • #613 DMV and Function drag/drop not working
  • #647 Hiding hidden objects was not working correctly with items in display folders
  • #643 fixing issue with code completion window "sticking"

v2.15.0

New Features

  • #559 Added a toolbar button and right-click menu to copy Server Timing metrics
  • #556 Added an option to play a sound after long running operations
  • Added "Duplicate Measure" right-click menu to Query Builder
  • Added Error events to All Queries trace
  • #568 Added right-click menu option in the editor to go to dax.guide for functions
  • #569 Added Function tooltip display when hovering the mouse over functions in the editor
  • Added setup cmdline parameter docs
  • Added SQLBI videos to docs
  • Added discussions link to website navigation
  • Updated Multiple Query Detection to work with // Dax Query in addition to // SQL Query comments

Fixes

  • Adding extra checks around QueryEnd timeout in Server Timings
  • Close the Trace Layout ribbon tab when all documents are closed
  • Made 'Add New' disabled in the Query Builder if the current model has no tables
  • Fixed #458 added docs and tooltip to explain memory sizes
  • Fixed #517 updated clipboard bindings to allow for copying from the View Metrics tabs
  • Fixed #539 error starting traces when using Roles or EffectiveUserName
  • Fixed bug in retry for ViewMetrics when there is an error reading statistical information.
  • Added configuration to read statistical data for VertiPaq Analyzer. Disable reading statistical data for legacy versions of SSAS. Added retry logic and log of warning if there is an error reading statistical data.
  • Fixed #525 F1 and Context Menu to open dax.guide for functions
  • Fixed server timings trace for PowerPivot
  • Fixed drag drop issues with QueryBuilder
  • Fixed #514 Server Trace not working in Excel
  • Fixed #520 option to not truncate tables was not working when exporting to SQL Server
  • Fixed #511 Excessive metadata refreshes was causing metadata pane to collapse
  • Fixed #512 fixed Table tooltip warnings and added measure count
  • Fixed #546 corrected wording in error message
  • Fixed #549 correctly escape connection string values containing special characters
  • Fixed #557 delimiter error on Clear Cache when using non-US delimiter style
  • Fixed a bug with the Roles parameter in the advanced connection properties not accepting spaces
  • Fixed #563 metadata incorrectly resetting when using a combination of mouse selection and query builder hotkeys
  • Fixed #564 Application crashes when clicking on a ribbon tab while the ribbon is collapsed
  • Fixed crash when resetting key bindings
  • Fixed #575 autocomplete sometimes stops working
  • Disabled the Add Measure button when connected to a model with no tables
  • Fixed #576 Editing an existing Measure in Query Builder against PowerPivot causes a crash

v2.14.1

Includes all the updates from v2.14.0

Fixes

  • Fixed #509 - critical issue with the Excel Addin that causes it to fail to load

v2.14.0

Updates

  • Added help text when the edit control is empty
  • Added privacy settings
  • Added options for improving the readability of the xmSQL in Server Timings
  • Added "Multiple Queries Detected" dialog when pasting in queries from Power BI Performance Analyzer that came from a Composite model
  • Help Ribbon updates
  • Query Builder moved out of preview status
  • Benchmarking moved out of preview status
  • Enabled Discussions on the github site
  • Adding Query Builder documentation to daxstudio.org
  • Updating AdomdClient and TOM references to v19.14
  • Added retry logic when fetching Database and Model lists
  • #450 Last Updated is now shown in local time instead of UTC
  • Added keyboard short cuts in metadata pane to work with Query Builder
  • #492 added description to function tooltip

Fixes

  • Fixed crash when doing Replace All with an invalid RegEx expression
  • Fixed crash when clicking Refresh Metadata after connection has dropped
  • Fixed #469 Server Timings busy spinner was activating incorrectly when doing Clear Cache
  • Fixed #467 Database Name was being incorrectly injected into all new connections when DAX Studio was opened from External Tools in Power BI Desktop
  • Fixed #466 PBI XMLA connections not being parsed correctly
  • Fixed #457 crashing on startup after setting view hidden objects = false in options
  • Fixed #356 Clear Cache throwing errors against PBI XMLA endpoint
  • Fixed #449 Connection lost during Benchmarking
  • Fixed a trace timeout issue when connecting to PBI XMLA endpoint (sometimes it is still necessary to increase the default timeout to 90 seconds or more)
  • Query Builder
    • Fixed a bug when filtering dates that reported an error parsing an empty string
    • Added the ability to drag KPI components into the Query Builder
    • Fixed a crash when trying to alter the expression for a dynamic format string for a calculation group item
  • Fixed hang when pasting in code with extremely long lines (tens of thousands of characters)
  • Fixed #451 up/down keys not work consistently
  • Fixed #446 Aggregate rewrite events causing an error
  • Fixed #444 to use correct culture in csv export
  • Fixed #445 defaulting the selected model to the base model not the first perspective
  • Fixed an issue with the trace layout options not displaying
  • Fixed a bug with swap delimiters feature and block comments
  • Apply a number of small fixes that should address some issues that came in via crash reports, but these reports were all submitted anonymously so for many of them it is impossible to verify that the fix has worked as we have no steps to reproduce the issue and the fix is based on assumptions of the cause of the issue.
  • Fixed drag/drop of text not working within editor
  • Fixed #475 proxy auth error when entering AAD credentials
  • Fixed #485 Swap delimiters incorrectly affecting functions with periods in the name
  • Fixed #486 Define Measure not using Separator specified in Options
  • Fixed #497 Define Measures not working when connected to a model with active translations
  • Fixed #499 Added table name when querying for column references
  • Fixed #501 avoiding bug with EXCEPT function in Query Builder

v2.13.1

Fixes

  • #442 Crash when opening New Measure or Edit Measure in Query Builder
  • #440 Extended time out for clean up of temporary odc files

v2.13

New / Enhanced

  • Added native Excel output so that the Dynamic and Static Excel outputs are always available (event when running outside of Excel)
  • #340 Added "Clipboard" as an output target
  • Re-write of the connection handling to incorporate a retry mechanism if the connection gets dropped
  • View Metrics
    • Fixed Sorting in View Metrics table view to do a nested sort
    • Changed Sorting in View Metrics to sort Descending on first click
    • Added "loading" status to View Metrics
    • View Metrics - Fixed KB/MB/GB (it was lowercase, which is for bits not bytes)
    • Enhancement #403 View Metrics - added tooltips, loading indicator, fixed default sort
  • Query Builder
    • Improved the query patterns generated by the Query Builder
    • Added Between/In/Not In filter types to Query Builder
  • New Options view with search and categories to make finding options easier
  • Export Data now uses TOPNSKIP in million row batches allowing for the export of massive data sets
  • Enhancement #385 added an option to prompt before refreshing metadata
  • Changed default Text file output to UTF-8 csv
  • Renamed "Excel" button to "Analyze in Excel" in External Tools
  • Added a check that the portable version is not in a restricted folder

Fixes

  • Fixed #400 duplicate New option in customize Quick Access Toolbar
  • Fixed #401 unable to re-show Power BI Performance window after hiding it
  • Fixed #405 & #415 incorrectly trying to write external tools file when doing a non-admin install
  • Fixed crashes when right-clicking on certain tool windows
  • Fixed #411 Export to csv not quoting strings
  • Fixed #404 improved code completion interactions
  • Fixed #424 Parameter parsing in table constructors
  • Fixed #419 View Metrics error against PowerPivot models

v2.12.2

Fixes

#398 Exception thrown on startup. Only occurs when there is no history of previous data sources.

v2.12.1

New Features

  • Pasting a connection string into the server name will parse out the Data Source and Initial Catalog settings

Fixes

  • #391 - issues when copying Power BI Performance data and pasting into Excel
  • #393 - application crashed if you attempted to open the Initial Catalog list before specifying a server
  • #394 - output to text file was not working for multiple results sets
  • #397 - "All Queries" trace was not working against PowerPivot connections

v2.12.0

New Features

  • Installer now signed with an EV certificate (kindly funded by SQLBI) this should prevent/minimize warnings from SmartScreen
  • Added "Initial Catalog" setting to the Advanced Options in the connection dialog, if you have a very large model or slow connection (like AzureAS or VPN) then you can now choose the initial database you are connected to.
  • Added Roles and IsAdmin properties to Database tooltip
  • #382 Changed "Format Query" to a split-button so that you can choose the style of formatting by clicking on the bottom half of the button
  • Adding Portable build as a download option

Fixes

  • #378 Power BI External Tools - installer not correctly updating path in daxstudio.pbitools.json file if a non-default install location is used
  • #377 exporting tables with no rows would throw an error
  • #376 autosave not recovering open files for all types of crashes
  • #374 improved tooltip sampling to prevent full column materialization
  • Fixed crash when attempting to export using invalid manual connection string
  • #381 re-connecting to a pbix file that has been closed and re-opened after launching from External Tools does not work

v2.11.2

Updates

  • Adds support for the "External Tools" ribbon in Power BI Desktop

Fixes

  • #373 Fixes "Define Measure" when connected to a SSAS instance without admin rights
  • #372 Duplicate MyMeasures created when adding more than 1 custom measure in the Query Builder
  • #367 Measure information duplicated in VPAX files
  • Fixed crash when highlighting
  • Fixed crash when closing last tab and connection had been lost

v2.11.1

Fixes

  • Filters on datetime columns where we cannot parse the date value now report the error rather than crashing when using the "Edit Query" button
  • #343 Fixed spelling of KEEPFILTERS for IS NOT filters
  • #345 Comma placement changed to match the style used by DaxFormatter
  • #346 / #347 DaxFormatter now works in the Expression Editor
  • #351 error while exporting tables to SQL Server
  • #352 hierarchies in display folders not expanding
  • #357 leading/trailing comments missing when doing "define measure"

v2.11.0

New Features

  • (Preview) Query Builder
  • (Preview) Query Benchmark
  • #314 Added Quick Access buttons for New, New (with current connection) & Save
  • #277 Added Export button to all trace outputs
  • Added full filename tooltip to tabs (thanks @dmarkle)
  • Promoted View Metrics (Vertipaq Analyzer) from preview status to general availability
  • Promoted Export Data feature from preview status to general availability
  • Documentation Updates:
    • Added license page
    • including a section on SmartScreen issues in Win10 (thanks to Gilbert at fourmoo.com )
  • Updated syntax highlighting to align with DaxFormatter.com
  • Added a note in the Database tooltip that the Database Id can be copied using a right-click
  • Added formatting to shorten asazure: and powerbi: server names in the status bar so that the key information is visible
  • Added a partitions tab to the Model Metrics views
  • Added a sample of any missing keys to the relationships tab in the Model Metrics (these keys are not saved for privacy reasons when exporting to a vpax file)

Fixes

  • fixed cancelling of exports to SQL Server
  • improved keyboard navigation by adding IsDefault/IsCancel properties to dialog buttons (thanks @dmarkle)
  • fixed an issue with intellisense not re-enabling after reconnecting (thanks @dmarkle)
  • fixed an issue with Query History pane not updating the "Current" Database filter when changing databases
  • disabled external tools when connected to PowerPivot
  • #290 updated all URL references to use https (thanks @warthurton)
  • #291 fixed issue connecting from Excel 2010
  • #301 refined the code completion to prevent it overwriting code when editing in the middle of an expression
  • #302 disabled column re-ordering in Metrics view
  • #303 fixed an issue with the metadata pane when connecting to a model with dynamic format strings defined in calculation groups
  • #308 removed backtick characters in column names with spaces where using the Static Excel output
  • #320 fixed server not found error when exporting vpax file for PowerPivot models
  • #325 fixed error when attempting to connect to PowerPivot files stored on OneDrive
  • #329 fixed incorrect database name shown when launched from the Excel addin and not connected to PowerPivot
  • #330 fixed the status message getting stuck after writing output to a file destination
  • #339 fixed a bug that reported an assembly load error when Cancelling a query

2.10.2

This minor update includes a couple of small new features and a few bug and crash fixes.

New Features

  • #274 Adding Editor Word Wrap to options screen
  • #270 Added option to display current user in title bar
  • Added Dax Formatter option to omit spaces after function names

Fixes

  • fixed crash when selecting PBI / SSDT connection, but not selecting a file
  • fixed crash when running a query that produces no rows and using the Static Excel Output
  • fixed #272 Vertipaq Analyzer not working if any tables have a single quote in the name
  • fixed a number of reported crashes
  • improved a number of background threading calls to use the simpler async/await pattern
  • moved checking for schema changes on activating DAX Studio to a background thread to prevent the UI freezing for slow connections (AAS) or if there are active commit locks.
  • fixed an issue preventing diagnostic logging from working with the Excel addin

2.10.1

  • Fixes a bug with Publish DAX Functions

2.10.0

New Features

  • #200 Added Database tooltip to show language & compatibility level
  • #195 Added option for using tabs vs spaces for indenting code
  • #188 Added settings to the Options window for a custom delimiter setting when exporting to a file.
  • Added Summary page to the Vertipaq Analyzer view
  • #228 Show an icon if a table is marked as a date table
  • Added buttons to the help ribbon for posting bugs and feature requests
  • Added tooltip to functions
  • #257 Added search box for DMV's and Functions
  • Added RI Violations information to Vertipaq Analyzer view
  • #181 Added custom key bindings (as a Preview feature)

Fixes

  • #251 fixed Startup crash "String not recognized as a valid datetime" after changing windows date format
  • #224 Server Timings and Query Plan traces now work with the EffectiveUsername connection string parameter
  • #237 fixed population of UserName field in traces
  • #223 Export Wizard now replaces characters that are not legal in file names with underscores
  • #222 UTF-8 csv exports no longer include BOM characters
  • #218 Vertipaq Analyzer - fixed an issue trying to export a model with a multiple of 50 +1 columns
  • #238 Vertipaq Analyzer - fixed Column Header name for Data Type column
  • Vertipaq Analyzer - fixed not showing any output for certain models #235 #231 #218
  • #213 fixed a bug that was not allowing "DEFINE MEASURE" to work with KPIs
  • #241 fixed File - New creating 2 blank windows (thanks @Mankarse)
  • #226 removed OnDragEnter debug message
  • #255 clicking "swap delimiters" clears the undo stack
  • Format button was not respecting the delimiter setting in the Options page
  • #254 Data Export wizard now excludes tables with no columns (as there is no data to export anyway)
  • Fixed the location and name of the diagnostics log files

2.9.4

This release fixes the following issues:

  • Unable to connect to PowerPivot models from Excel Add-in
  • Application crash when double-clicking on DMVs and Functions

And includes all the following items from version 2.9.3

New Features

  • Integrated Vertipaq Analyzer (preview feature)
  • Updated Data Export Wizard (preview feature)
  • #215 Right-click on Database to copy the name
  • #214 Ability to sort on any column in query results
  • #188 Option for custom delimiter when exporting to file

Fixes

  • #212 Syntax highlighting for WHERE in DMV queries
  • improved load performance for Server Timings, All Queries trace and Power BI Performance data
  • #204 Fixed crashes when doing multi-line pastes
  • #205 ensure TLS 1.2 is used when connecting to DaxFormatter
  • #202 Added tooltip for Load Power BI Performance Data button
  • #201 fix crashes when using ctl-tab to switch tabs, or when undocking tabs
  • #196 fix cancel button being disabled by clear cache and run
  • #199 shift-double-click
  • #198 fixing context menu icons

2.9.3

This release includes a number of stability and performance fixes as well as some new and updated preview features (enable these in the advance tab in the options page)

New Features

  • Integrated Vertipaq Analyzer (preview feature)
  • Updated Data Export Wizard (preview feature)
  • #215 Right-click on Database to copy the name
  • #214 Ability to sort on any column in query results
  • #188 Option for custom delimiter when exporting to file

Fixes

  • #212 Syntax highlighting for WHERE in DMV queries
  • improved load performance for Server Timings, All Queries trace and Power BI Performance data
  • #204 Fixed crashes when doing multi-line pastes
  • #205 ensure TLS 1.2 is used when connecting to DaxFormatter
  • #202 Added tooltip for Load Power BI Performance Data button
  • #201 fix crashes when using ctl-tab to switch tabs, or when undocking tabs
  • #196 fix cancel button being disabled by clear cache and run
  • #199 shift-double-click
  • #198 fixing context menu icons

2.9.2

This release fixes the following issues:

  • #189 Fixing issues with loading metadata
    • Hierarchies in folders were causing an infinite loop
    • Certain combinations of folder names with and with out spaces were causing partial loading of metadata
  • #193 A warning message box is now displayed when attempting to open a file from the recent files list that has been deleted, renamed or moved.

Minor Enhancements:

  • #192 Folders are now sorted first by default in the metadata pane (you can switch back to the old pure alphabetical behaviour using an option in File -> Options)
  • #185 Added Visual Name to the header comment when copying query from PowerBI performance data to the query window
  • Metadata loading performance has been improved by upto 6x

2.9.1

Fixing #184 where Display Folders were not displaying in Power BI Desktop

2.9.0

New Features

  • Import Power BI Performance Data
  • Support for Display Folders in the Metadata pane #127
  • Added options to enable/disable the automatic metadata refresh by connection type (local/network/cloud) #182
  • Option to hide hidden objects in the metadata pane #167 (can also be toggled from right-click menu)
  • PowerBI auto-date template and variation tables (as these can't be directly queried)
  • Option for metdata search to be pinned open #151
  • Option to increase width of intellisense window #152
  • Adding show referenced objects option on metadata right-click (thanks @DaveStabilify) #144
  • Option for setting 'Clear Cache and Run' as the default run style #86

Bug Fixes

  • Fixes #175 - Handling of quotes in csv export
  • Fixes #177 - Scrollbars not displayed in recent files list
  • Fixes #180 - error when tracing connections using Roles=
  • Fixed a bug where changing connections did not always update the selected database
  • Fixed issues with crash recovery of unsaved changes

Internals

  • Refactored unit tests and ADOTabular dll to allow unit tests to be run automatically during appveyor builds
  • Adding Database Name column to all traces to work with the new Power BI XMLA endpoint
  • Updating AMO/ADOMD library references

2.8.4

Improvements

  • Includes a workaround for an issue in the Power BI XMLA endpoint which prevents Timing/Query Plan traces from starting
  • Moved the display of aggregate rewrite events in the All Queries trace out of preview status.

Fixes the following issues:

  • #169 display Table description in metadata pane tooltips
  • #171 Quoting all text fields when exporting to CSV
  • #166 Fixing paste behaviour when pasting over selected text
  • Fixes incorrect font units of scale. font sizes will appear slightly larger as previously fonts size were implemented in pixels (96 per inch) instead of points (72 per inch)

2.8.3

  • Fixes #124 often not able to connect to Direct Query models in Power BI Desktop
  • Prevents Power BI getting stuck at "loading..." if Power BI has a dialog window open
  • Fixes #157 showing metadata for wrong database on initial connection
  • Fixes #147 external tools preview feature being displayed incorrectly
  • prevent crash when trying to display tooltips under certain edge conditions
  • Merged #156 improved error trapping for data export (thanks @albertospelta )