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 (14)
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.
RE: DAX Debugger
Awesome IDEA !!!
definively need it !!
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.
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...
RE: DAX Debugger
Relationship tracing when debugging DAX is required especially if there is a possibility of ambiguous relationships or bidi.
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.
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.
RE: DAX Debugger
This is must required to debug DAX developer. Do needful
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
RE: DAX Debugger
What would be useful in Power BI Desktop would be to enable "Debug mode" and then click any data value point on a visual, or grid cell and invoke a graphical debug that shows what tables are involved and what filtering is being applied (step by step)