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

7b584ff4 8798-49f7-badd-d01280f204ad 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

a38b8ec5 24a2-4197-9eec-d694cfd8bae9 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

5266d1c3 e225-4014-b550-a431c6e2d616 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

5266d1c3 e225-4014-b550-a431c6e2d616 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

e1d5f53c b7ee-4a59-b080-2bb846a7b658 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

218d2e8e cf1d-424c-a764-84dea4c93b46 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

fdc8da54 8ee1-4e86-886d-96f8a1cddaa1 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.