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

dax_studio_2

Latest changes

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

2.14.1

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

2.14.0

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
Fixed – Large number of bug fixes

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.