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!
Khoi Do commented
I'm using March 2019 update. The intellisense is still tooooooo slow. Is the engine different from the Intellisense in SQL Server Management Studio?
As at today am using PowerBI and I can say that intellisense is working not only in advanced editor but also formula bar. But for it to work you have to use the advanced editor first and add some step(s). Then when yiu go to formula bar the intellisense works.
Haven't tried using formula bar intellisense without using advanced editor first though.
Does anyone know why M intellisense keyboard shortcuts (like: CTRL + SHIFT + L) aren't functioning anymore? They seem to have disappeared after December's update ... any news/ help would be appreciated!
Mario Lorenzo commented
I like this tip! So usefull!
The highlight of words is no longer available in the editor :(
The preview InteliSense is great! Thank you Power Bi team!
Michiel Rozema commented
Some feedback on the recent changes in the Advanced Editor, introducing intellisense on M. This is a great feature, but as Mike Hardy states, it needs more work and is very slow at the moment. Some other issues I have:
- What REALLY drives me crazy is the warning when closing the editor with the Cancel button. Open the Advanced Editor, do nothing, Cancel - Are you sure you want to cancel? with... a Cancel button! That cancels the cancellation!
- The Editor wants to do too much. I don't need the current line to be highlighted, and when I click a word I don't need all other occurrences of that word to be highlighted (this may be useful in some cases, but now many highlights occur that have nothing to do with the selected item. When entering a new line somewhere in the script, when typing in the first name I don't need the next line to display red wiggles; I know I'm not done typing. Please make this configurable.
- Small suggestion: when I open the Editor to e.g. paste a copied M script, I cannot select all with CTRL+A. Instead, I have to click in the Editor and then CTRL+A works. It would make sense to be in edit mode right away.
- This is probably a preview thing, but when entering a function (slow) the pop-up seems to be clickable by the hand cursor that is shown. This does nothing, however.
What I do like a lot is that a double-click on a composed name like #"Promoted Headers" now selects the name. Before, a double-click on e.g. Promoted only selected the word Promoted and there was no easy way to select the name as a whole. Nice!
Mike Hardy commented
It just made it to the Advanced Editor as a preview feature which is fantastic. Unfortunately looks like it needs some more work. It's so slow and causes so much lag it's unusable. I have 6 cores, 64G and nothing else running. At least it's a start! Thanks.
Well, it is in the App Store version today for the advanced editor only. Not in the formula bar yet.
ed hansberry commented
"Before the end of 2016...."
I think we are a bit past 2016.... :-)
Looking forward! The added value is to see all the available options into categories.
Better for learning
Someone created a interesting view, (If I could remember the author who produced the example, I would plug the author's website
Jakob Kornum commented
Very important feature indeed. An autoformatting function would also be greatly appreciated.
@Ben Sacheri, you can also get syntax highlighting and some light intellisense from the PowerQuery extension in VS Code and Visual Studio, but why this hasn't been implemented in the query editor in Excel or Power BI yet is beyond me.
Ben Sacheri commented
The current editor has a lot to be desired. It's annoying when I click my cursor between characters and drag the mouse to select text that the selection starting and ending positions jump to include more. It's like it's forcing me to select a "word" but it's never what I want.
The best editor I've founds so far is Notepad++ with the M language formatting. Here is more info about it:
Amazing started almost two years ago. This must be so fantastic when it finally comes out... ;-P
But on a more proper tone. Please this is vital. We also need this on the Excel version of power query
Have to agree with several on here that the customer focus of MSFT is lacking if we get status updates like "STARTED" 2 years ago and we haven't been updated since. This is an easy way to lose the respect of a customer base and potentially customers overall. Please do a better job updating the us!
wajid noor commented
what happened to this Idea? You gave a rough timeline of end of 2016 and it's almost half of 2018 but no improvements yet?
Adam Kruzel commented
It gets to be a hassle writing the code in Notepad++ so I can make sure brackets are in the right place and words are automatically filled out to only copy and paste it into Power BI and tells me something is wrong. Would be great if the Power Query editor acted more the Mgmt Studio.
Hi, is there any update to this? The M advanced editor in its current form is pretty awful!
Any update on this please? I just downloaded the latest desktop version. The new features are welcome but I'd happily trade them all for some basic editor features.