equivalent of DAX studio for M?

[ValeriaBreve]

Hello,

sorry if this is a dumb question.

I am having issues with PowerQuery in Desktop performance. For my more complex queries, when I write in the editor, I literally have to wait seconds before I see any letter typed appear. It has become a real pain... I have to go letter by letter, wait for each one to appear, type again if it does not show...

I was wondering if there is an equivalent of DAX studio for PowerQuery, where I could write my code and test it, and then paste it back in PowerBI Desktop. 

I have tried Visual Studio Code with the M language extension, however it does not connect to the report (or I have not figured out how to do it)

Hope what I wrote makes sense - thanks for your guidance!

Kind regards

Valeria

[AntrikshSharma · Accepted solution]

@ValeriaBreve How much data are you loading, maybe due to file size there is an issue? There is an extension for Visual Studio that allows you to write M code and return the result as well, try that.

Extension:

[ValeriaBreve]

Thanks! I had not seen this one. I installed it yesterday, need some time to figure out how to use it, but looks exactly like what I need 🙂

[HotChilli]

"For my more complex queries, when I write in the editor, I literally have to wait seconds before I see any letter typed appear" - possibly a problem with Intellisense rather than query execution.

You could try to turn it off from the Power Query options page as an experiment

[ValeriaBreve]

Hello! For this report in particular, I seem to be getting at ~ 100 lines or code or more... and the model has many queries (I am right now at 90). Not all of them have 100 lines of M code, but many do... yes I know nightmare scenario.... but at least PowerQuery allows me to do such a good preparation that data analysis is then possible!!! (which was not before)

[ams1]

Hi,

IMO there are NO dumb questions 😊.

Complex means how many lines of code?