Skip to main content

Power BI

Completed

Improve the Advanced Query Editor

Vote (837) Share
Taylor Clark's profile image

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)
Taylor Clark's profile image Profile Picture

f0175a8f 2091-4f0e-902f-01527c5e3501 on 05 Jul 2020 23:22:06

RE: Improve the Advanced Query Editor

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
)

https://app.powerbi.com/view?r=eyJrIjoiYjhhNTczYWUtN2MyOS00ZjkxLWI2ZWYtOWU2NjYwMGIxZWVhIiwidCI6IjIzMWRkOWNkLWRkYzctNGZiYS1hZTc4LTlmNGFjM2M5MTJlNyIsImMiOjN9

Taylor Clark's profile image Profile Picture

37e881e8 1781-4c9b-80fe-1fc8550f87b8 on 05 Jul 2020 23:21:22

RE: Improve the Advanced Query Editor

Very important feature indeed. An autoformatting function would also be greatly appreciated.

Taylor Clark's profile image Profile Picture

848fe56b 6ba0-481f-a091-f236939904b7 on 05 Jul 2020 23:20:47

RE: Improve the Advanced Query Editor

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:
https://ssbi-blog.de/technical-topics-english/power-query-editor-using-notepad/

Taylor Clark's profile image Profile Picture

79bdc3b3 cbf8-49bf-8bf1-0efa7a7acac4 on 05 Jul 2020 23:20:14

RE: Improve the Advanced Query Editor

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

Taylor Clark's profile image Profile Picture

9e0d24c8 1744-4191-8761-f723ccbdcd64 on 05 Jul 2020 23:19:09

RE: Improve the Advanced Query Editor

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?

Taylor Clark's profile image Profile Picture

1f01e070 45e1-472b-bab7-05c477366026 on 05 Jul 2020 23:18:54

RE: Improve the Advanced Query Editor

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.

Taylor Clark's profile image Profile Picture

d2fcee0a e6d4-448f-8a96-5ee04f5fa9c0 on 05 Jul 2020 23:18:27

RE: Improve the Advanced Query Editor

Hi, is there any update to this? The M advanced editor in its current form is pretty awful!

Taylor Clark's profile image Profile Picture

fe10d4ed 40bc-4eda-9e8a-40577717ef1c on 05 Jul 2020 23:17:22

RE: Improve the Advanced Query Editor

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.

Taylor Clark's profile image Profile Picture

041fa873 3c53-4081-bae9-868454199a11 on 05 Jul 2020 23:17:07

RE: Improve the Advanced Query Editor

Already 2018 has started, when are you planning to implement this feature. Your deadline was 2 years back

Taylor Clark's profile image Profile Picture

a1b6f815 3d51-436e-8a82-fd0f725a6ba4 on 05 Jul 2020 23:16:26

RE: Improve the Advanced Query Editor

现在都没有更新啊