Skip to main content
Microsoft Idea

Power BI

Needs Votes

DAX Debugger

Vote (189) Share
Ronen Portnoy's profile image

Ronen Portnoy on 07 May 2017 19:31:12

Add capability to debug DAX code i.e. being able to step through DAX code, add Watch for expressions and variables and most importantly, be able to view the table/DATA change according to the current row/filter context in the code step

Comments (15)
Ronen Portnoy's profile image Profile Picture

Kostas Matricola on 06 Jun 2023 10:44:25

RE: DAX Debugger

Please add a debug procedure, DAX is getting more complicated and we need a way to debug the code. At least add the evaluate&log functionality inside desktop

Ronen Portnoy's profile image Profile Picture

Ryan McKee on 06 Jul 2020 00:03:53

RE: DAX Debugger

Would love to get an update on this. Debugging your DAX code can sometimes take forever. Having the functionality where you are able to highlight the points of evaluation in your DAX code would be a huge time saver. The trace dependents/precedents functionality in excel would also be a great additional functionality to view which measures are dependent on other measures.

Ronen Portnoy's profile image Profile Picture

Power BI User on 05 Jul 2020 23:56:22

RE: DAX Debugger

Awesome IDEA !!!
definively need it !!

Ronen Portnoy's profile image Profile Picture

Joseph Carrier on 05 Jul 2020 23:50:42

RE: DAX Debugger

Microsoft Power BI team please provide an update on this. This is mandatory for all other coding languages (and DAX is unlike most other coding languages). DAX studio can only do so much to decipher filter context and formula logic. Moreover, when DAX functions work in conjunction (e.g. context transition), the end result can be completely altered. A step by step highlighting on the DAX formula at points of evaluation, interim tables, context transitions, etc. is definitely needed. Thanks.

Ronen Portnoy's profile image Profile Picture

Power BI User on 05 Jul 2020 23:49:45

RE: DAX Debugger

This is crucial. As soon as your model grows and especially when you have to deal with inactive relationships (so you use USERELATIONSHIP or CROSSFILTER) you basically have to "guesswork" what's happening under the hood.
Because if you don't use them you can add a table and slicers and see how your filter works, but once you switch contexts and use those, it's impossible...

Ronen Portnoy's profile image Profile Picture

Christer Karlsson on 05 Jul 2020 23:49:27

RE: DAX Debugger

Relationship tracing when debugging DAX is required especially if there is a possibility of ambiguous relationships or bidi.

Ronen Portnoy's profile image Profile Picture

Erika Varble on 05 Jul 2020 23:44:17

RE: DAX Debugger

Right now, figuring out where the issues are in my DAX code is much more difficult than it should be. I would really like to be able to step through the process, so I can see where it's going sideways, like I can in Excel VB. Right now it's a lot of teasing apart and guesswork, which is so slow and annoying.

Ronen Portnoy's profile image Profile Picture

maddy on 05 Jul 2020 23:39:47

RE: DAX Debugger

Also there is no way to check the performance of the report unless we use a third party tool like DAX studio. I think DAX debugger would help it.

Ronen Portnoy's profile image Profile Picture

Pranav on 05 Jul 2020 23:39:03

RE: DAX Debugger

This is must required to debug DAX developer. Do needful

Ronen Portnoy's profile image Profile Picture

Power BI User on 05 Jul 2020 23:29:14

RE: DAX Debugger

this should be bread and butter of dax developer. i wonder why not many people vote for this feature. maybe dax is not as popular as i would love to see