DAX Studio

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.

NEW VERSION 2.7.1: Added support to detect Power BI Desktop installed from Windows Store. Minor bug fixes.

NEW VERSION 2.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.

NEW VERSION 2.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.

NEW VERSION 2.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.

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

NEW VERSION 2.3: 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.

NEW VERSION 2.2: 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.

NEW VERSION 2.1: new query profiling, integration with DAX Formatter, metadata search, connection to Power BI Desktop, and analysis of MDX queries to Tabular.

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

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.

Please, give your feedback and vote the new features.


 Enclose code in comments with <PRE></PRE> to preserve indentation.