The ultimate software for working with DAX queries for PC

DAX Studio

DAX Studio

  -  9.9 MB  -  Open Source
  • Latest Version

    DAX Studio 3.0.11 LATEST

  • Review by

    Daniel Leblanc

  • Operating System

    Windows XP / Vista / Windows 7 / Windows 8 / Windows 10

  • User Rating

    Click to vote
  • Author / Product

    SQLBI Corp. / External Link

  • Filename


DAX Studio is a tool to write, execute, and analyze DAX queries in Power BI Designer, Power Pivot for Excel, and Analysis Services Tabular. DAX Studio is the ultimate tool for executing and analyzing DAX queries against Microsoft Tabular models

It includes an Object Browser, query editing and execution, formula and measure editing, syntax highlighting and formatting, integrated tracing, and query execution breakdowns.

DAX Studio is a client tool for executing DAX queries against various data sources including:
  • PowerPivot in Excel
  • Power BI Desktop / SSDT Integrated Workspaces
  • Analysis Services Tabular
  • Azure Analysis Services
It will scan the local machine for any running instances of Power BI Desktop or SSDT Integrated Workspaces

Integrated DaxFormatter Support
It has integrated support for allowing you to consistently format your DAX directly in the editor.

Server Timings
DAXStudio can collect detailed query execution statistics to help when doing performance tuning.

Swap Delimiters
IT can help you to easily swap the delimiter style for DAX expressions.

  • DAX Studio 3.0.11 Screenshots

    The images below have been resized. Click on them to view the screenshots in full size.

    DAX Studio 3.0.11 Screenshot 1
  • DAX Studio 3.0.11 Screenshot 2
  • DAX Studio 3.0.11 Screenshot 3
  • DAX Studio 3.0.11 Screenshot 4

What's new in this version:

- Improved Query Folding logic
- updated vpax libraries
- no longer counting RowNumber as user column in vertipaq analyzer
- updated vpax libraries
- updated TOM / ADOMD libraries

- "An item with the same key has already been added" error when connecting to Power BI
- error when testing roles on SSAS
fixed bug in status bar for powerpivot connections
- detection of multiple parameters on one line
- Query Builder new measure showing permissions issue
- vertipaq analyzer summary always shows unknown.pbix
- error when loading perf data
Fixed Query Folding crashes with certain regional settings
- cancelling closing DAX Studio also cancels closing open documents
- error when opening files with Query Builder open