The ultimate software for working with DAX queries for PC

DAX Studio

DAX Studio

  -  11.1 MB  -  Open Source
  • Latest Version

    DAX Studio 3.2.1 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

    DaxStudio_3_2_1_setup.exe

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 DaxFomatter.com 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.2.1 Screenshots

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

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

What's new in this version:

Updated:
- Adding DAX parameter support to CSV & XLSX commands
- Improved Jumplist integration

Fixed:
- grid output not binding results with > or & in the column name
- Vertipaq Options dialog learn more link broken
- Adding Advanced XLSX output settings in Options
- Fixing DirectLake mode option not working in View Metrics dialog
- All Queries not capturing events
- dscmd VPAX command not using default value for StatsColumnBatchSize
- fixing crash on exit