Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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 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:
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 🙂
"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
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)
Hi,
IMO there are NO dumb questions 😊.
Complex means how many lines of code?