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 (67)
RE: Improve the Advanced Query Editor
I second this! Miguel, do you have any update to share with us? Thanks
RE: Improve the Advanced Query Editor
Any news on this improvement?
RE: Improve the Advanced Query Editor
I second every comment above and want to add a request for better highlighting and selection with a mouse.
Who designed that feature. It feels like it is designed to specificly frustrate me when I am attempting to copy and paste any code. How did you make it so good at preventing me from selecting what I actually want???
RE: Improve the Advanced Query Editor
Otherwise it is hard to read and write there.
RE: Improve the Advanced Query Editor
OMG. This is the best!!
RE: Improve the Advanced Query Editor
Thank you Miguel!
RE: Improve the Advanced Query Editor
And give the user the ability to change the font size!
RE: Improve the Advanced Query Editor
I can but join the clamour asking for an improved editor. Given that languages such as Python have managed to be integrated with Visual Studio, bringing all the benefits such as support for intellisense, could that not be the fist step?
We would then use this "advanced" editor [which it isn't] merely as the means of pasting code developed elsewhere, which we all do now but using VS rather than Notepad++ which seems to be the frontrunner at present.
The long-term aim has to be intellisense etc native to the product but VS integration would be a good first step along that road
RE: Improve the Advanced Query Editor
Best idea ever, Intellisense for Excel Power Query and Power BI Desktop
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++