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

02117b63 a0de-4a45-a4a9-b64a0fdb98ea on 05 Jul 2020 22:19:50

RE: Improve the Advanced Query Editor

Do this ASAP. eagerly waiting

Taylor Clark's profile image Profile Picture

83a80f93 a478-44b8-a216-0644470a3007 on 05 Jul 2020 22:19:46

RE: Improve the Advanced Query Editor

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

Taylor Clark's profile image Profile Picture

37c9ec07 3db7-e711-8117-c4346bb5988c on 05 Jul 2020 22:19:42

RE: Improve the Advanced Query Editor

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 ;)

Taylor Clark's profile image Profile Picture

9e1bbf75 65cc-4d33-99c1-a83470f242cc on 05 Jul 2020 22:19:36

RE: Improve the Advanced Query Editor

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

Taylor Clark's profile image Profile Picture

eab141ef e590-4823-88cb-a4a29d98a666 on 05 Jul 2020 22:19:33

RE: Improve the Advanced Query Editor

For the love of God please do this.

Taylor Clark's profile image Profile Picture

d8cbeb2b 9f8f-4736-8c89-0226b97e8ab0 on 05 Jul 2020 22:19:29

RE: Improve the Advanced Query Editor

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.

Taylor Clark's profile image Profile Picture

9279d8b7 430f-4d3e-b21a-b8c798ffce68 on 05 Jul 2020 22:19:29

RE: Improve the Advanced Query Editor

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)

Taylor Clark's profile image Profile Picture

069cd0df f734-41ec-9f6c-e871183d0046 on 05 Jul 2020 22:19:29

RE: Improve the Advanced Query Editor

This would increase the number of users

Taylor Clark's profile image Profile Picture

e6f6f46f dcf1-4991-9e7b-62a6fcd42924 on 05 Jul 2020 22:19:29

RE: Improve the Advanced Query Editor

And how about automatically managing those pesky commas?

Taylor Clark's profile image Profile Picture

f7d44449 9563-4e41-876e-a71230ff0423 on 05 Jul 2020 22:18:18

RE: Improve the Advanced Query Editor

Writing code in Notepad ++ and then copying and pasting into the advanced editor is not very convenient