DAX Studio is a tool to write, execute, and analyze DAX queries in Power BI Designer, Power Pivot for Excel, and Analysis Services Tabular.

It includes an Object Browser, query editing and execution, formula and measure editing, syntax highlighting and formatting, integrated tracing, and query execution breakdowns.

August 24, 2022: read more about the new major release of DAX Studio v3.0.0.

Visit http://daxstudio.org to read the full documentation and download the latest release of DAX Studio. The project is open source on GitHub.
Darren Gosbell is original author and the maintainer of the project, which has many contributors. SQLBI provides the EV code signing certificate and appears as the publisher of the tool, which can be safely downloaded and installed without SmartScreen warnings.

Latest changes

3.2.1

Added – DAX parameter support to CSV & XLSX commands
Added – Advanced XLSX output settings in Options
Improved – Jumplist integration
Fixed – Grid output not binding results with > or & in the column name
Fixed – Vertipaq Options dialog learn more link broken
Fixed – Fixing DirectLake mode option not working in View Metrics dialog
Fixed – All Queries not capturing events
Fixed – dscmd VPAX command not using default value for StatsColumnBatchSize
Fixed – Crash on exit

3.2.0

Added – Support for View Metrics StatsColumnBatchSize
Added – Sorting to ViewAs roles
Improved – Smart Paste
Fixed – Styling so trace command bars are not blurred
Fixed – Capturing server timing events when Auto ClearCache is active against powerbi:// endpoints
Fixed – dscmd CSV command not working with –connectionstring option
Fixed – dscmd export command –tables option parsing
Fixed – QueryBuilder measure renaming not working
Fixed – dscmd CSV command error when exporting some queries
Fixed – Sizing of status bar server name tooltip

3.1.1

Fixed – Error sending results to static Excel output

3.1.0

Added – Capture Diagnostics
Added – Evaluate and Log trace
Added – Database dialog when connecting
Added – Command line support
Added – Model Metrics / Vertipaq Analyzer Options dialog
Added – Support for obfuscated model metrics
Added – Support to Server Timings for the new ExecutionMetrics event
Added – “learn more” link to connection dialog
Added – Storage mode column to the Partitions tab in View Metrics
Added – Server FE Benchmark out of preview status
Updated – Listview selected row color lighter to improve the contrast
Updated – Improved labelling of the zoom level
Updated – TOM, ADOMD and other 3rd party dependencies
Updated – Fixed the images for the Server Timings event type filters
Fixed – crash trying to show fonts in the option dialog
Fixed – Formatted file export not applying formatting
Fixed – Loading of AggregateRewrite events in saved Server Timings
Fixed – Occasional crash when using publish functions
Fixed – Query Builder not respecting delimiter setting
Fixed – Reconnect active traces on connection retries
Fixed – Issue in QueryBuilder when loading a saved query containing a hierarchy
Fixed – Issue in QueryBuilder when trying to filter on a query scoped measure
Fixed – Issue where the Ribbon buttons get stuck in a disabled state after an error while a trace is active
Fixed – ViewAs not working with “Other User” option against the Power BI Service
Fixed – Status bar timer stopped too early
Fixed – View As dialog did not work properly with a large number of roles

3.0.11

Updated – Improved Query Folding logic
Updated – Latest VPAX libraries
Updated – No longer counting RowNumber as user column in vertipaq analyzer
Updated – Latest TOM / ADOMD libraries
Fixed – “An item with the same key has already been added” error when connecting to Power BI
Fixed – Error when testing roles on SSAS
Fixed – Bug in status bar for powerpivot connections
Fixed – Detection of multiple parameters on one line
Fixed – Query Builder new measure showing permissions issue
Fixed – VertiPaq analyzer summary always shows unknown.pbix
Fixed – Error when loading perf data
Fixed – Query Folding crashes with certain regional settings
Fixed – Cancelling closing DAX Studio also cancels closing open documents
Fixed – Error when opening files with Query Builder open

3.0.10

Fixed – Crash dialog that appears when connecting or changing tabs when the Indent Based Folding preview feature is NOT enabled

3.0.9

Updated – Vertipaq Analyzer libraries to work with DAX Optimizer
Added – Preview Feature – Indent Based Code Folding
Fixed – Saved Server Timings not loading
Fixed – Add escaping to find references
Fixed – Define measure in calculation groups
Fixed – Typo in Query Builder
Fixed – Sorting by Translated Names
Fixed – Improved DQ formatting

3.0.8

Added – Include dynamic format string in Define Measure
Added – winget publishing to release pipeline
Added – Added hierarchy support to Query Builder
Added – Allows for dragging entire tables to Query Builder
Updated – Improved metadata refresh against Fabric Direct Lake models
Fixed – Rendering issues in View Metrics
Fixed – Assembly signing in automated build process
Fixed – Bracket highlighting for CallbackDataID in Server Timings
Fixed – Prevented multiple trace windows when opening files
Fixed – Query Builder not saving if user has read-only access
Fixed – Clear any previous errors at the start of Server Timings trace
Fixed – Corrected spelling of Power Pivot
Fixed – Recovering multiple documents can set the wrong active document
Fixed – Right-click copy in results was incorrectly copying all cells
Fixed – Error when using data export to SQL and column name has square brackets
Fixed – Crash in hierarchy tooltip
Fixed – Crash reports
Fixed – Improved autosave clean up
Fixed – Display of database name when connected to PBI Desktop
Fixed – Improved autosave cleanup
Fixed – Bug in expand measures

3.0.7

Added – Clear Log and Clear Results context menu options
Added – Preview option for exporting Server Timings text to separate files
Fixed – Spelling mistake in installer option
Fixed – xmlReader in use errors
Fixed – incorrect hash calculation
Fixed – issue with line comments when using linked Excel output
Fixed – min/max not populating in tooltips for some DQ models
Fixed linked Excel output not working with AAD authentication
Fixed crash on ctrl+shift+c
Fixed Object not set error in Query Builder
Fixed an issue loading older versions of ServerTimings data
Fixed issues relating to a couple of reported crashes

3.0.6

Added – Copy with/without headers option for query results
Added – Duplicate option to tab right-click menu
Added – Open a .dax file by dragging it onto DAX Studio
Added – Encoding option for custom CSV output
Added – Formatted File as an output option
Added – Json option when outputting to a file
Added – Server FE Benchmark (preview)
Added – Default file name when exporting bim from vpax
Updated – Moved Swap Delimiters / Debug Commas to advanced
Updated – Timeline/Waterfall visualization in Server Timings
Updated – xmSQL / DirectQuery formatting improvements
Updated – moved preview and vertipaq analyzer settings from the advanced to the standard options page
Fixed – fix vertipaq analyzer showing in summary pane for AAS / PBIP
Fixed – Enabling Shift+Enter to be used as a custom hotkey
Fixed – Disabled re-ordering of columns in vertipaq analyzer
Fixed – Fix location of desktop shortcut file for Current User installs
Fixed – QueryBuilder measures missing table references when loading from file
Fixed – QueryBuilder IN filters not loading from file correctly
Fixed – Improving VertiPaq Analyzer tooltips
Fixed – Fixing spelling / capitalization errors
Fixed – Tool Window incorrectly docking
Fixed – Permission error on non-admin install
Fixed – Improved color contrast in dark mode
Fixed – Adjusted measure icon position when vertical scrollbars are always displayed
Fixed – Adding support for measure filters in Query Builder
Fixed – Display of columns with open parenthesis as first character
Fixed – Metadata display for multi-dimensional models
Fixed – Skip showing crash dialog if app is shutting down
Fixed – Improved generation of Define Measure and Define Dependent Measures
Fixed – Crash in BindableFocusBehaviour and AutomationPeer
fixed – Cell alignment in View Metrics columns tab
Fixed – Crash on update flag click event
Fixed – Crash when browsing for a folder during CSV data export
Fixed – Improvements for FE duration calculation
Fixed – Hidden table icon
Fixed – Excel tracing
Fixed – Invalid button states after failed connection attempt

3.0.5

Fixed – Permissions error when installing for Current User
Fixed – Colors on Getting Started dialog
Fixed – Incorrect new version notification on the initial install

3.0.4

Added – Query information button to traces
Updated – Query History icons
Updated – Exposed Theme/Mode setting in Options
Added – MPARAMETER keyword to syntax highlighting
Fixed – Error exporting to static Excel file
Fixed – crash when dragging trace windows
Fixed – incorrect link to tutorial in Getting Started dialog
Fixed – Define and Expand sometimes producing incorrect output
Fixed – username blank in All Queries trace
Fixed – increased default code completion window width
Fixed – automatically select all text in find/replace dialog
Fixed – improved waterfall layout in Server Timings
Fixed – setting focus in the editor when changing tabs
Fixed – file icon registration
Added – Extra hotkey validation rules
Added – Retry logic to all clipboard operations
Improved – Error handling around shutdown operations
Improved – Power BI filename detection for non-English cultures
Removed – Unused dependencies and reduced installer/portable file size

3.0.0

New User Interface
Updated – Improved state tracking for trace windows
Updated – Prevented interleaving of clearcache with query execution
Updated – Added PowerPivot model detection timeout in options
Updated – Syntax highlighting to handle multi-line strings
Added – Highlighting of cache nodes in physical query plans

2.17.3

Added – Parameter support to Query Builder filters
Updated – Removing tags from xmSQL in Server Timings to improve readability
Updated – Accuracy of Server Timings for queries with Batch events
Updated – Query builder queries are now captured in the query history
Added – The /f parameter can now open vpax files
Added – Extra information to the error message when the XMLA endpoint is not correctly enabled
Updated – Improved caching of measure expressions
Fixed – Preventing a crash when entering a proxy password
Fixed – Added DOUBLE data type to auto-complete and syntax highlighting
Fixed – Export to Excel failed on some machines
Fixed – Saving parameters to XML was not correctly encoding special characters
Fixed – Crash on startup if the WMI information on the machine was corrupt
Fixed – download link in Help – About screen
Fixed – not loading the model metadata when the regional settings for the current machine uses something other than a period (.) for the decimal separator
Fixed – crash in the QueryBuilder when the model metadata has not loaded correctly

2.16.2

Fixed – Traces fail to start with a timeout error (regression in 2.16.1)
Minor fixes

2.16.1

Minor fixes

2.16.0

Added – “Preview Data” right-click option for tables and columns
Added – Extended parameter support to include data types other than text
Added – “New Version” notification in the title bar
Added – Auto-Generate button to Query Builder
Added – ORDER BY support to the Query Builder
Added – Ctrl+W to select the current word
Added – Encoding option when using Exporting Data to CSV files
Added – Extending installer support for Windows ARM64
Added preview feature – Debug Commas – moves commas in formatted queries to the start of the line
Added preview feature – Show XMLA Commands in All Queries trace – shows commands sent by other tools like SSDT and Tabular Editor
Updated – xmSQL cleanup to also fix table names
Updated – Supporting all of the /f /s /d command line parameters at the same time
Updated – Query Builder Improvements
Updated – Clicking Edit Query from the Query Builder will now update any previously generated query text
Updated – Custom Key-Bindings moved out of preview
Updated – Extending Hover tooltip to work with Keywords
Updated – Show PBIX filename in the database dropdown instead of database ID
Updated – updating ADOMD / AMO references to 19.22
Fixed – Analyze in Excel not working with PBI XMLA or AzureAS
Fixed – Server Timings Layout Tab not appearing
Fixed – Issue with code completion window “sticking”
Fixed – other minor bugs fixed in this release

2.15.0

Added – Toolbar button and right-click menu to copy Server Timing metrics
Added – 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
Added – Right-click menu option in the editor to go to dax.guide for functions
Added – Function tooltip display when hovering the mouse over functions in the editor
Added – Discussions link to website navigation
Updated – Multiple Query Detection to work with // Dax Query comments in composite models
Fixed – more than 25 bugs fixed in this release

You can watch a video about profiling a query with DAX Studio by Marco Russo, who also wrote about new tracing features in version 2.1.

Issues

Please, give your feedback and vote for your favorite features.

DAX Studio

v3.2.1

Published on Sep 5, 2024

Change log & Old Versions

v3.2.1 (Sep 5, 2024)

Added - DAX parameter support to CSV & XLSX commands
Added - Advanced XLSX output settings in Options
Improved - Jumplist integration
Fixed - Grid output not binding results with > or & in the column name
Fixed - Vertipaq Options dialog learn more link broken
Fixed - Fixing DirectLake mode option not working in View Metrics dialog
Fixed - All Queries not capturing events
Fixed - dscmd VPAX command not using default value for StatsColumnBatchSize
Fixed - Crash on exit

v3.2.0 (Aug 8, 2024)

Added - Support for View Metrics StatsColumnBatchSize
Added - Sorting to ViewAs roles
Improved - Smart Paste
Fixed - Styling so trace command bars are not blurred
Fixed - Capturing server timing events when Auto ClearCache is active against powerbi:// endpoints
Fixed - dscmd CSV command not working with --connectionstring option
Fixed - dscmd export command --tables option parsing
Fixed - QueryBuilder measure renaming not working
Fixed - dscmd CSV command error when exporting some queries
Fixed - Sizing of status bar server name tooltip

v3.1.1 (Aug 1, 2024)

Fixed - Error sending results to static Excel output

v3.1.0 (Jul 31, 2024)

Added - Capture Diagnostics
Added - Evaluate and Log trace
Added - Database dialog when connecting
Added - Command line support
Added - Model Metrics / Vertipaq Analyzer Options dialog
Added - Support for obfuscated model metrics
Added - Support to Server Timings for the new ExecutionMetrics event
Added - "learn more" link to connection dialog
Added - Storage mode column to the Partitions tab in View Metrics
Added - Server FE Benchmark out of preview status
Updated - Listview selected row color lighter to improve the contrast
Updated - Improved labelling of the zoom level
Updated - TOM, ADOMD and other 3rd party dependencies
Updated - Fixed the images for the Server Timings event type filters

v3.0.11 (Nov 21, 2023)

Updated - Improved Query Folding logic
Updated - Latest VPAX libraries
Updated - No longer counting RowNumber as user column in vertipaq analyzer
Updated - Latest TOM / ADOMD libraries
Fixed - "An item with the same key has already been added" error when connecting to Power BI
Fixed - Error when testing roles on SSAS
Fixed - Bug in status bar for powerpivot connections
Fixed - Detection of multiple parameters on one line
Fixed - Query Builder new measure showing permissions issue
Fixed - VertiPaq analyzer summary always shows unknown.pbix
Fixed - Error when loading perf data
Fixed - Query Folding crashes with certain regional settings
Fixed - Cancelling closing DAX Studio also cancels closing open documents
Fixed - Error when opening files with Query Builder open

v3.0.10 (Aug 16, 2023)

Fixed - Crash dialog that appears when connecting or changing tabs when the Indent Based Folding preview feature is NOT enabled

v3.0.9 (Aug 15, 2023)

Updated - Vertipaq Analyzer libraries to work with DAX Optimizer
Added - Preview Feature - Indent Based Code Folding
Fixed - Saved Server Timings not loading
Fixed - Add escaping to find references
Fixed - Define measure in calculation groups
Fixed - Typo in Query Builder
Fixed - Sorting by Translated Names
Fixed - Improved DQ formatting

v3.0.8 (Jul 3, 2023)

Added - Include dynamic format string in Define Measure
Added - winget publishing to release pipeline
Updated - Improved metadata refresh against Fabric Direct Lake models
Added - Added hierarchy support to Query Builder
Added - Allows for dragging entire tables to Query Builder
Fixed - Rendering issues in View Metrics
Fixed - Assembly signing in automated build process
Fixed - Bracket highlighting for CallbackDataID in Server Timings
Fixed - Prevented multiple trace windows when opening files
Fixed - Query Builder not saving if user has read-only access
Fixed - Clear any previous errors at the start of Server Timings trace
Fixed - Corrected spelling of Power Pivot
Fixed - Recovering multiple documents can set the wrong active document
Fixed - Right-click copy in results was incorrectly copying all cells
Fixed - Error when using data export to SQL and column name has square brackets
Fixed - Crash in hierarchy tooltip
Fixed - Crash reports
Fixed - Improved autosave clean up
Fixed - Display of database name when connected to PBI Desktop
Fixed - Improved autosave cleanup
Fixed - Bug in expand measures

v3.0.7 (Apr 18, 2023)

Added - Clear Log and Clear Results context menu options
Added - Preview option for exporting Server Timings text to separate files
Fixed - Spelling mistake in installer option
Fixed - xmlReader in use errors
Fixed - incorrect hash calculation
Fixed - issue with line comments when using linked Excel output
Fixed - min/max not populating in tooltips for some DQ models
Fixed linked Excel output not working with AAD authentication
Fixed crash on ctrl+shift+c
Fixed Object not set error in Query Builder
Fixed an issue loading older versions of ServerTimings data
Fixed issues relating to a couple of reported crashes

v3.0.6 (Mar 14, 2023)

Added - Copy with/without headers option for query results
Added - Duplicate option to tab right-click menu
Added - Open a .dax file by dragging it onto DAX Studio
Added - Encoding option for custom CSV output
Added - Formatted File as an output option
Added - Json option when outputting to a file
Added - Server FE Benchmark (preview)
Added - Default file name when exporting bim from vpax
Updated - Moved Swap Delimiters / Debug Commas to advanced
Updated - Timeline/Waterfall visualization in Server Timings
Updated - xmSQL / DirectQuery formatting improvements
Updated - moved preview and vertipaq analyzer settings from the advanced to the standard options page
Fixed - fix vertipaq analyzer showing in summary pane for AAS / PBIP
Fixed - Enabling Shift+Enter to be used as a custom hotkey
Fixed - Disabled re-ordering of columns in vertipaq analyzer
Fixed - Fix location of desktop shortcut file for Current User installs
Fixed - QueryBuilder measures missing table references when loading from file
Fixed - QueryBuilder IN filters not loading from file correctly
Fixed - Improving VertiPaq Analyzer tooltips
Fixed - Fixing spelling / capitalization errors
Fixed - Tool Window incorrectly docking
Fixed - Permission error on non-admin install
Fixed - Improved color contrast in dark mode
Fixed - Adjusted measure icon position when vertical scrollbars are always displayed
Fixed - Adding support for measure filters in Query Builder
Fixed - Display of columns with open parenthesis as first character
Fixed - Metadata display for multi-dimensional models
Fixed - Skip showing crash dialog if app is shutting down
Fixed - Improved generation of Define Measure and Define Dependent Measures
Fixed - Crash in BindableFocusBehaviour and AutomationPeer
fixed - Cell alignment in View Metrics columns tab
Fixed - Crash on update flag click event
Fixed - Crash when browsing for a folder during CSV data export
Fixed - Improvements for FE duration calculation
Fixed - Hidden table icon
Fixed - Excel tracing
Fixed - Invalid button states after failed connection attempt

v3.0.5 (Oct 27, 2022)

Fixed permissions error when installing for Current User
Fixed colors on Getting Started dialog
Fixed incorrect new version notification on the initial install

v3.0.4 (Sep 26, 2022)

Added - Query information button to traces
Updated - Query History icons
Updated - Exposed Theme/Mode setting in Options
Added - MPARAMETER keyword to syntax highlighting
Fixed - Error exporting to static Excel file
Fixed - crash when dragging trace windows
Fixed - incorrect link to tutorial in Getting Started dialog
Fixed - Define and Expand sometimes producing incorrect output
Fixed - username blank in All Queries trace
Fixed - increased default code completion window width
Fixed - automatically select all text in find/replace dialog
Fixed - improved waterfall layout in Server Timings
Fixed - setting focus in the editor when changing tabs
Fixed - file icon registration
Added - Extra hotkey validation rules
Added - Retry logic to all clipboard operations
Improved - Error handling around shutdown operations
Improved - Power BI filename detection for non-English cultures
Removed - Unused dependencies and reduced installer/portable file size
Fixed - Missing shortcut icon

v3.0.0 (Aug 24, 2022)

New User Interface
Updated - Improved state tracking for trace windows
Updated - Prevented interleaving of clearcache with query execution
Updated - Added PowerPivot model detection timeout in options
Updated - Syntax highlighting to handle multi-line strings
Added - Highlighting of cache nodes in physical query plans

v2.17.3 (Nov 17, 2021)

Added - Parameter support to Query Builder filters
Updated - Removing tags from xmSQL in Server Timings to improve readability
Updated - Accuracy of Server Timings for queries with Batch events
Updated - Query builder queries are now captured in the query history
Added - The /f parameter can now open vpax files
Added - Extra information to the error message when the XMLA endpoint is not correctly enabled
Updated - Improved caching of measure expressions
Fixed - Preventing a crash when entering a proxy password
Fixed - Added DOUBLE data type to auto-complete and syntax highlighting
Fixed - Export to Excel failed on some machines
Fixed - Saving parameters to XML was not correctly encoding special characters
Fixed - Crash on startup if the WMI information on the machine was corrupt
Fixed - download link in Help - About screen
Fixed - not loading the model metadata when the regional settings for the current machine uses something other than a period (.) for the decimal separator
Fixed - crash in the QueryBuilder when the model metadata has not loaded correctly

v2.16.2 (Jul 13, 2021)

Fixed - Traces fail to start with a timeout error (regression in 2.16.1)
Fixed - Showing View Metrics Last Refreshed and Analysis Date in the local timezone
Fixed - When saving a file with the Query Builder open custom measure names were not saved
Fixed - Debug commas not handling lines with indented comments correctly
Fixed - View Metrics - Last Refreshed date was incorrectly adjusting from UTC time

v2.16.1 (Jun 28, 2021)

Fixed - 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)
Fixed - Unable to open a new query tab either with a new connection or with a copied connection
Fixed - Passing the database name on the command line

v2.16.0 (Jun 22, 2021)

Added - "Preview Data" right-click option for tables and columns
Added - Extended parameter support to include data types other than text
Added - "New Version" notification in the title bar
Added - Auto-Generate button to Query Builder
Added - ORDER BY support to the Query Builder
Added - Ctrl+W to select current word
Added - Encoding option when using Exporting Data to CSV files
Added - Extending installer support for Windows ARM64
Added preview feature - Debug Commas - moves commas in formated queries to the start of the line
Added preview feature - Show XMLA Commands in All Queries trace - shows commands sent by other tools like SSDT and Tabular Editor
Updated - xmSQL cleanup to also fix table names
Updated - Supporting all of the /f /s /d command line parameters at the same time
Updated - Query Builder Improvements
Updated - Clicking Edit Query from the Query Builder will now update any previously generated query text
Updated - Custom Key-Bindings moved out of preview
Updated - Extending Hover tooltip to work with Keywords
Updated - Show PBIX filename in the database dropdown instead of database ID
Updated - updating ADOMD / AMO references to 19.22
Fixed - Analyze in Excel not working with PBI XMLA or AzureAS
Fixed - Server Timings Layout Tab not appearing
Fixed - Issue with code completion window "sticking"
Fixed - other minor bugs fixed in this release

v2.15.0 (Mar 28, 2021)

Added - Toolbar button and right-click menu to copy Server Timing metrics
Added - 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
Added - Right-click menu option in the editor to go to dax.guide for functions
Added - Function tooltip display when hovering the mouse over functions in the editor
Added - Discussions link to website navigation
Updated - Multiple Query Detection to work with // Dax Query comments in composite models
Fixed - more than 25 bugs fixed in this release

v2.14.1 (Jan 19, 2021)

Fixed - Critical issue with the Excel Add-In that causes it to fail to load

v2.14.0 (Jan 18, 2021)

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
Added - Query Builder moved out of preview status, documentation available in daxstudio.org
Added - Benchmarking moved out of preview status
Added - Enabled Discussions on the github site
Added - Query Builder documentation to daxstudio.org
Added - Retry logic when fetching Database and Model lists
Changed - Help Ribbon updates
Changed - Updating AdomdClient and TOM references to v19.14
Changed - Last Updated is now shown in local time instead of UTC
Large number of bug fixes

v2.13.1 (Oct 22, 2020)

Fixed - Crash when opening New Measure or Edit Measure in Query Builder
Fixed - Extended time out for clean up of temporary odc files

v2.13.0 (Oct 20, 2020)

Added - Native Excel output so that the Dynamic and Static Excel outputs are always available
Added - Clipboard as an output target
Fixed - Connection handling incorporates a retry mechanism if the connection gets dropped
Fixed - Fixed Sorting in View Metrics table view to do a nested sort
Fixed - Changed Sorting in View Metrics to sort Descending on first click
Added - "loading" status to View Metrics
Fixed - View Metrics - Fixed KB/MB/GB (it was lowercase, which is for bits not bytes)
Added - Improved the query patterns generated by the Query Builder
Added - Added Between/In/Not In filter types to Query Builder
Added - New Options view with search and categories to make finding options easier
Added - Export Data now uses TOPNSKIP in million row batches allowing for the export of massive data sets
Added - Option to prompt before refreshing metadata
Changed - Default Text file output to UTF-8 csv
Changed - Renamed "Excel" button to "Analyze in Excel" in External Tools
Added - Check that the portable version is not in a restricted folder
Fixed - Duplicate New option in customize Quick Access Toolbar
Fixed - Unable to re-show Power BI Performance window after hiding it
Fixed - Incorrectly trying to write external tools file when doing a non-admin install
Fixed - Crashes when right-clicking on certain tool windows
Fixed - Export to csv not quoting strings
Fixed - Improved code completion interactions
Fixed - Parameter parsing in table constructors
Fixed - View Metrics error against PowerPivot models

v2.12.2 (Aug 4, 2020)

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

v2.12.1 (Aug 3, 2020)

Added - Pasting a connection string into the server name will parse out the Data Source and Initial Catalog settings
Fixed - Issues when copying Power BI Performance data and pasting into Excel
Fixed - Application crashed if you attempted to open the Initial Catalog list before specifying a server
Fixed - Output to text file was not working for multiple results sets
Fixed - "All Queries" trace was not working against PowerPivot connections

v2.12.0 (Jul 28, 2020)

Added - Installer now signed with an EV certificate that prevent warnings from SmartScreen
Added - "Initial Catalog" setting to the Advanced Options in the connection dialog, to choose the initial database when connecting to a very large model or slow connection (like AzureAS or VPN). This minimizes the metadata retrieved from the server before providing control to the user.
Added - Roles and IsAdmin properties to Database tooltip
Added - "Format Query" has a split-button to choose the style of formatting by clicking on the bottom half of the button
Added - Portable build as a download option
Fixed - Power BI External Tools - installer not correctly updating path in daxstudio.pbitools.json file if a non-default install location is used
Fixed - Exporting tables with no rows would throw an error
Fixed - Autosave not recovering open files for all types of crashes
Fixed - Improved tooltip sampling to prevent full column materialization
Fixed - Crash when attempting to export using invalid manual connection string
Fixed - Re-connecting to a pbix file that has been closed and re-opened after launching from External Tools does not work

v2.11.2 (Jul 14, 2020)

Added - Support for the "External Tools" ribbon in Power BI Desktop
Fixed - "Define Measure" when connected to a SSAS instance without admin rights
Fixed - (Query Builder preview) Duplicate MyMeasures created when adding more than 1 custom measure
Fixed - Measure information duplicated in VPAX files
Fixed - Crash when highlighting
Fixed - Crash when closing last tab and connection had been lost

v2.11.1 (Jun 18, 2020)

Fixed - (Query Builder preview) Filters on datetime columns when a date value is incorrect in "Edit Query" button
Fixed - (Query Builder preview) Spelling of KEEPFILTERS for IS NOT filters
Fixed - (Query Builder preview) Comma placement changed to match the style used by DaxFormatter
Fixed - (Query Builder preview) DaxFormatter now works in the Expression Editor
Fixed - Error while exporting tables to SQL Server
Fixed - Hierarchies in display folders not expanding
Fixed - Leading/trailing comments missing when doing "define measure"

v2.11.0 (Jun 8, 2020)

Added - (Preview) Query Builder
Added - (Preview) Query Benchmark
Added - Quick Access buttons for New, New (with current connection) & Save
Added - Export button to all trace outputs
Added - Full filename tooltip to tabs
Promoted View Metrics (Vertipaq Analyzer) from preview status to general availability
Promoted Export Data feature from preview status to general availability
Updated syntax highlighting to align with DaxFormatter.com
Added - 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 - Partitions tab to the Model Metrics views
Added - 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)
Several other fixes

v2.10.2 (Jan 20, 2020)

Added - Option to enable word wrap in editor
Added - Option to display current user in title bar
Added - Option to omit spaces after function names using Dax Formatter
Fix - crash when selecting PBI / SSDT connection, but not selecting a file
Fix - crash when running a query that produces no rows and using the Static Excel Output
Fix - Vertipaq Analyzer not working if any tables have a single quote in the name
Fix - a number of reported crashes
Fix - improved a number of background threading calls to use the simpler async/await pattern
Fix - 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.
Fix - fixed an issue preventing diagnostic logging from working with the Excel addin

v2.10.1 (Dec 20, 2019)

Added - Database tooltip to show language & compatibility level
Added - Option for using tabs vs spaces for indenting code
Added - Settings to the Options window for a custom delimiter setting when exporting to a file.
Added - Summary page to the Vertipaq Analyzer view
Added - 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
Added - Search box for DMV's and Functions
Added - Referential Integrity Violations information to Vertipaq Analyzer view
Added - Custom key bindings (as a Preview feature)
Fix - Fixed Startup crash "String not recognized as a valid datetime" after changing windows date format
Fix - Server Timings and Query Plan traces now work with the EffectiveUsername connection string parameter
Fix - Fixed population of UserName field in traces
Fix - Export Wizard now replaces characters that are not legal in file names with underscores
Fix - UTF-8 csv exports no longer include BOM characters
Fix - Vertipaq Analyzer - fixed an issue trying to export a model with a multiple of 50 +1 columns
Fix - Vertipaq Analyzer - fixed Column Header name for Data Type column
Fix - Vertipaq Analyzer - fixed not showing any output for certain models #235 #231 #218
Fix - Fixed a bug that was not allowing "DEFINE MEASURE" to work with KPIs
Fix - Fixed File - New creating 2 blank windows (thanks @Mankarse)
Fix - Removed OnDragEnter debug message
Fix - Clicking "swap delimiters" clears the undo stack
Fix - Format button was not respecting the delimiter setting in the Options page
Fix - Data Export wizard now excludes tables with no columns (as there is no data to export anyway)
Fix - Fixed the location and name of the diagnostics log files

v2.9.4 (Sep 15, 2019)

Added - Integrated Vertipaq Analyzer (preview feature)
Added - Updated Data Export Wizard (preview feature)
Added - Right-click on Database to copy the name
Added - Ability to sort on any column in query results
Added - Option for custom delimiter when exporting to file
Fix - Syntax highlighting for WHERE in DMV queries
Optimization - Improved load performance for Server Timings, All Queries trace and Power BI Performance data
Fix - Fixed crashes when doing multi-line pastes
Fix - Ensure TLS 1.2 is used when connecting to DaxFormatter
Fix - Added tooltip for Load Power BI Performance Data button
Fix - Fix crashes when using ctl-tab to switch tabs, or when undocking tabs
Fix - Fix cancel button being disabled by clear cache and run
Fix - Shift-double-click
Fix - Fixing context menu icons

v2.9.2 (Jun 26, 2019)

Fix - Issues with loading metadata (Hierarchies in folders were causing an infinite loop, partial loading of metadata for certain names)
Fix - Warning message if a file from the recent files list that has been deleted, renamed or moved.
Added - Folders sorted first by default in the metadata pane
Added - Visual Name to the header comment when copying query from PowerBI performance data to the query window
Optimization - Metadata loading performance improved up to 6x

v2.9.1 (Jun 4, 2019)

Fix - Columns now showed in tables with Display Folders

v2.9.0 (Jun 3, 2019)

Added - Import Power BI Performance Data
Added - Support for Display Folders in the Metadata pane
Added - Options to enable/disable the automatic metadata refresh by connection type (local/network/cloud)
Added - Option to hide hidden objects in the metadata pane and auto-date template and variation tables
Added - Option for metdata search to be pinned open
Added - Option to increase width of intellisense window
Added - Adding show referenced objects option on metadata right-click
Added - Option for setting 'Clear Cache and Run' as the default run style
Fix - Handling of quotes in csv export
Fix - Scrollbars not displayed in recent files list
Fix - Error when tracing connections using Roles
Fix - Fixed a bug where changing connections did not always update the selected database
Fix - Fixed issues with crash recovery of unsaved changes

v2.8.4 (Mar 31, 2019)

Change - Moved the display of aggregate rewrite events in the All Queries trace out of preview status
Fix - Includes a workaround for an issue in the Power BI XMLA endpoint which prevents Timing/Query Plan traces from starting
Fix - Display Table description in metadata pane tooltips
Fix - Quoting all text fields when exporting to CSV
Fix - Fixing paste behaviour when pasting over selected text
Fix - 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)

v2.8.3 (Mar 12, 2019)

Fix - often not able to connect to Direct Query models in Power BI Desktop
Fix - Prevents Power BI getting stuck at "loading..." if Power BI has a dialog window open
Fix - showing metadata for wrong database on initial connection
Fix - external tools preview feature being displayed incorrectly
Fix - prevent crash when trying to display tooltips under certain edge conditions
Improved error trapping for data export

v2.8.2 (Feb 3, 2019)

Fixed Code Completion not correct when table names have underscores
Fixed Parameter dialog incorrectly triggered by @ character inside strings
Fixed SQL Profiler button was incorrectly enabled
Fixed "Define All Measures" option incorrectly shown when right-clicking on Measure
Scanning for Power BI instances in connection dialog moved to a background thread

v2.8.1 (Jan 23, 2019)

Fixed a crash when launching DAX Studio by double-clicking on a .dax file
Fixed a crash when opening a file after closing all other windows
Fixed a random crash when clicking on various tabs

v2.8.0 (Jan 22, 2019)

Filter Dump Measure
Define All Measures
Parameter UI
Auto-Save
Goto Line
Updated Data Provider libraries for connecting to Azure AS, PowerBI.com and Power BI Desktop
Support for Power BI Aggregation events in ServerTimings and AllQueries traces
Digitally Signed
Option to zoom results grid with query text
Optimized tracing of Direct Query for newer engine sources
Added links to dax.guide into function tooltips in code completion window
Option to set results grid font size
Added hotkey Ctrl-Shift-N to open a new query with the same connection
Added VAR & RETURN to the code completion keywords
Numerous stability fixes

v2.7.4 (Feb 20, 2018)

Support for multiple result sets.
Added connection to SSDT Integrated Workspaces.
Automatic refresh of metadata after editing data mode.
Notification when a newer version is available.
Improved metadata search performance.
Several bug fixes and improvements in stability.

Dec 2-4, 2024
Copenhagen