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

Dan Ahlvin 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

Taylor Clark's profile image Profile Picture

Paul on 05 Jul 2020 22:18:17

RE: Improve the Advanced Query Editor

Adding Intellisense to PBI Desktop would be really useful and helpful.

Taylor Clark's profile image Profile Picture

Nick Morris on 05 Jul 2020 22:17:52

RE: Improve the Advanced Query Editor

Also, add syntax prompts (like in Excel) to help build queries, and a direct access to a better reference for the commands

Taylor Clark's profile image Profile Picture

amien on 05 Jul 2020 22:10:48

RE: Improve the Advanced Query Editor

'+1 for the highlighting errors and also a find shortcut (Ctrl-F)

Taylor Clark's profile image Profile Picture

amien on 05 Jul 2020 22:10:48

RE: Improve the Advanced Query Editor

forgot : autocompleting of statements and shows the parameters which are needed for the statement

Taylor Clark's profile image Profile Picture

Power BI User on 05 Jul 2020 22:03:16

RE: Improve the Advanced Query Editor

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.

Taylor Clark's profile image Profile Picture

Stas Antropov on 05 Jul 2020 22:00:10

RE: Improve the Advanced Query Editor

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.

Taylor Clark's profile image Profile Picture

Aldis on 05 Jul 2020 21:59:29

RE: Improve the Advanced Query Editor

Please add the auto-complete for the formula editor for custom columns.