DAX Studio

daxstudio_logo

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.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.

DAX Studio is a project on CodePlex – visit http://daxstudio.codeplex.com to read the full documentation, download the installer and the source code.

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.