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

    5f88169e 873f-4ba9-9914-33576bbab5c2 on 05 Jul 2020 23:02:58

    RE: Improve the Advanced Query Editor

    This is the major missing piece in Power Query, IMO.

    The inbuilt functions are really well organized, but making them more discoverable and getting some help with the required parameters would speed up the workflow a lot.

    Taylor Clark's profile image Profile Picture

    c4516d79 05bb-4202-aece-d65aa41fcefb on 05 Jul 2020 23:02:48

    RE: Improve the Advanced Query Editor

    Please do implement this. Most of my code is WALLOFTEXT and hard to deal with.

    Taylor Clark's profile image Profile Picture

    ca381371 de5b-4ce4-8816-85bfe2106504 on 05 Jul 2020 22:59:32

    RE: Improve the Advanced Query Editor

    Please please please bring this along :)

    Taylor Clark's profile image Profile Picture

    abba35d1 1de5-4617-8c8b-c97ff098c557 on 05 Jul 2020 22:58:59

    RE: Improve the Advanced Query Editor

    Needs to be at least as good as the DAX / R-script support. Admittedly, constrained by needing to be compatible with script generation, but some decent IntelliSense is basic, especially as many users may not have the deep experience needed to use Power query properly

    Taylor Clark's profile image Profile Picture

    672763b3 b499-4c30-9b24-68d5e7c3683d on 05 Jul 2020 22:57:10

    RE: Improve the Advanced Query Editor

    Really needed feature

    Taylor Clark's profile image Profile Picture

    e705f47e e2f6-4247-be79-0826252152fa on 05 Jul 2020 22:56:44

    RE: Improve the Advanced Query Editor

    Give us please IntelliSense for M!

    Taylor Clark's profile image Profile Picture

    217a8526 71e6-41c8-bd4c-1278192e996c on 05 Jul 2020 22:56:26

    RE: Improve the Advanced Query Editor

    Hello,

    Any update on the M IntelliSense ?

    The fact that it was released for VS is a positive signal but it's been months now since then and we are all holding our breaths here pretty much.

    Taylor Clark's profile image Profile Picture

    9480cdac 8928-4314-920b-1d67563100e9 on 05 Jul 2020 22:49:56

    RE: Improve the Advanced Query Editor

    Hi - Any update on this as it would be really useful. FYI you could follow along making it work with Notepad++ here
    https://www.youtube.com/watch?v=oHWQCggChuU&index=37&list=PLDz00l_jz6zzttb28XH8GHZNL6vvpBlkQ&t=2s

    Taylor Clark's profile image Profile Picture

    25a77610 65c1-4a44-9d5e-fc85d4540007 on 05 Jul 2020 22:47:23

    RE: Improve the Advanced Query Editor

    DAX authoring is significantly improved with the latest SSDT and SSMS releases and we know that M is built into SSAS 2017. Given its importance to PBI and MSBI projects, I'm hopeful the M development/authoring experience is improved soon. Any updates? :)

    Taylor Clark's profile image Profile Picture

    83c57e61 3348-47ef-9280-1bfedca064f8 on 05 Jul 2020 22:45:17

    RE: Improve the Advanced Query Editor

    Is there a news about ?