Taylor Clark on 13 Mar 2015 06:42:04
Add better static analysis, IntelliSense, and general formatting abilities (like allowing tabs) in the "Advanced" editor
Administrator on 13 Apr 2019 01:32:42
We're glad to let you know that this feature is now Generally Available. Please refer to the Power BI Desktop April release announcement for more details: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-2019-feature-summary/ Thanks for your feedback!
- Comments (68)
RE: Improve the Advanced Query Editor
In the beginning, I was quite puzzled that: 1) The "Advanced Editor" is not even a basic editor for M scripting (e.g. far less capable than Notepad V1.0)
2) M has about double the functions of Excel, yet there's no Intellisense
3) In recent times, proper case for default steps names was replaced with spaced names that end up with ugly and error prone characters in the resulting script.
Finally, it occurred to me that the "advanced" editor was designed as a way of viewing recorded steps and making light modifications. It was never designed to do anything substantial, like creating scripts from scratch, or making substantial modifications to recorded scripts.
I made my peace with the editor a long time ago when it became clear that it was not going to get better anytime soon (that was about two years ago, and it turned out to be true).
I get the syntax highlighting, function intellisense and all of the editing functionality that I need in NotePad++. The advanced editor is merely used to paste scripts created in NotePad++
RE: Improve the Advanced Query Editor
Do this ASAP. eagerly waiting
RE: Improve the Advanced Query Editor
Is this still under review or are you already working on this?
RE: Improve the Advanced Query Editor
This would be a massive help for productivity.
It obviously wouldn't be a v1.0 but Visual Studio integration would make out job so much easier (imagine intellisence, load to pbix and TFS integration). Baby steps ;)
RE: Improve the Advanced Query Editor
'+3 - would make things much easier. Thanks.
RE: Improve the Advanced Query Editor
For the love of God please do this.
RE: Improve the Advanced Query Editor
I also rely on Notepad ++ and love it for how helpful it is (Thank you Don Ho & team!). But I'd much rather have the suggested improvements right in the various Power BI Editors.
RE: Improve the Advanced Query Editor
Not just the Advanced Editor please. Add Intellisense to the Add Custom Column dialog as well (and make sure it gets to Excel, not just Power BI Desktop)
RE: Improve the Advanced Query Editor
This would increase the number of users
RE: Improve the Advanced Query Editor
And how about automatically managing those pesky commas?