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

2.8.4

Minor bug fixes.

2.8.3

Minor bug fixes.

2.8.2

Minor bug fixes.

2.8.1

Minor bug fixes.

v2.8.0

New DAX code generation features: Filter Dump Measure, Define All Measures.
Editor features: Parameter UI, Auto-Save, Goto Line, Option to zoom and set font size in results grid, links to dax.guide into function tooltips, hotkey Ctrl-Shift-N to open a new query
Other improvements: 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, Optimized tracing of Direct Query for newer engine sources
Many bug fixes.
Find more details in the blog post by Darren Gosbell.

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.