DAX Studio – Great tool to debug your DAX Queries for Power BI Projects

Hi Folks,

In this digital era, every Power Platform individual want to make more with their data. So obviously there are gonna using Power BI to provide great insights with their data.

Coming to reporting, every one knows to create their visuals in Power BI Desktop and publish them to Power BI Service to view the Power BI Dashboards in Dataverse. This is common and known by everyone. But if you go a bit deeper and want to build some complex Power BI visuals, you were going to definitely use DAX(Data Analysis Expressions). If you were new to DAX, look at this tutorial to gain more information on how to write them.

Next step is when you were writing the DAX expressions, might be in Measures or Calculated functions(including calculated tables, calculated columns) you can’t just write them out at first shot and publish your reports. Definitely it takes time and effort to write them and make the look syntactically formatted so that every one can understand. So you may need to debug your DAX expressions before you actually use them in your reports. It’s when DAX Studio comes as savior which can be integrated with Power BI Desktop in few simple steps.

First step is to download DAX Studio and install it. As soon you are done, you should be able to see in external tools tab.

When you open any Power BI report, you can open them directly from DAX Studio.

You can then open your DAX queries in your DAX Studio and then run/debug your queries, view the performance statistics etc.

DAX Studio is an open source tool which every BI Developer can leverage to improve your productivity in their projects.

Reference:

Video Reference

Web reference

Hope this helps….

Cheers,

PMDY