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.

Visit http://daxstudio.org to read the full documentation and download the latest release of DAX Studio. The project is open source on GitHub.

dax_studio_2

Latest changes

v2.7.4

Fixes an issue with the clear cache button not working.

v2.7.3

Minor update to fix connectivity issues with Analysis Services 2012..

v2.7.2

Minor bug fixes. More details in the blog post by Darren Gosbell.

v2.7.1

Added support to detect Power BI Desktop installed from Windows Store. Minor bug fixes.

v2.7.0

Capture all queries run on a client, support for Azure AS, enhanced tooltips displaying min/max/distinct count values of each column plus random sample of 10 values, define dependent measures when right-click on a measure, publish/export functions to capture versions of DAX functions. Several bug fixes and improvements in stability. Added CrashReporter.net to manage submission of crash reports. Watch the video of improvements in the debug experience recorded by Marco Russo. Find more details in the blog post by Darren Gosbell.

v2.6.0

Support for multiple result sets, added connection to SSDT Integrated Workspaces, automatic refresh of metadata after editing data model, notification when a newer version is available, improved metadata search performance, and the search box now stays open when it has keyboard focus. Several bug fixes and improvements in stability.

v2.5.0

New option to enable Trace for DirectQuery events, added rows and KB to Server timings tab, optimized calls to DAX Formatter service, small bug fixes, and minor improvements.

v2.4.1

Toggle delimiter switch between US (,) and European (;), Intellisense improvements and many small fixes.

v2.3.0

New Query History Pane, improved parsing of query plans & traces, support for SQL Server 2016, copy measure definition in editor, more configuration options, minor fixes.

v2.2.0

New support to tracing for Power Pivot, basic implementation of IntelliSense, connect to Multidimensional SSAS Servers, support for multiple Power BI Desktop instances, highlight unnatural hierarchies.

Darren Gosbell wrote about the new features in DAX Studio 2.2.

v2.1.0

New query profiling, integration with DAX Formatter, metadata search, connection to Power BI Desktop, and analysis of MDX queries to Tabular.

Paul te Braak published an introduction to DAX Studio on his blog.

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 the new features.