Improve the Advanced Query Editor
Add better static analysis, IntelliSense, and general formatting abilities (like allowing tabs) in the "Advanced" editor
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!
Ken Puls commented
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)
Dan Ahlvin commented
Writing code in Notepad ++ and then copying and pasting into the advanced editor is not very convenient
Adding Intellisense to PBI Desktop would be really useful and helpful.
Nick Morris commented
Also, add syntax prompts (like in Excel) to help build queries, and a direct access to a better reference for the commands
forgot : autocompleting of statements and shows the parameters which are needed for the statement
+1 for the highlighting errors and also a find shortcut (Ctrl-F)
1. Advanced Editor should remember size of window upon previous close.
2. Change Advanced Editor to Non-Modal window to allow continuous editing/updating while viewing results.
Stas Antropov commented
I think the advanced editor also needs to have syntax highlighting. It would be great also to have a keyboard shortcut for invoking the advanced editor without having to right-click on a query.
Please add the auto-complete for the formula editor for custom columns.