Improve the Advanced Query Editor

[TaylorClark]

Add better static analysis, IntelliSense, and general formatting abilities (like allowing tabs) in the "Advanced" editor

[vba]

'+3 - would make things much easier. Thanks.

[Brian_smith8097]

For the love of God please do this.

[ELIAS2]

This would increase the number of users

[alex_jankowski]

And how about automatically managing those pesky commas?

[oculusoraculi]

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 😉

[orlando_mezqui1]

Is this still under review or are you already working on this?

[jonstiel]

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.

[colinbanfield1]

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++

[fbcideas_migusr]

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)

[ted_eichinger]

Best idea ever, Intellisense for Excel Power Query and Power BI Desktop