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

    Nasir Shaikh on 05 Jul 2020 23:04:08

    RE: Improve the Advanced Query Editor

    Hello,

    Any update on the M Intellisense? Target was end of 2016, now 2017 is about to end!

    Taylor Clark's profile image Profile Picture

    Power BI User 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

    Ba rt 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

    Collin Taylor 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

    John Dawson 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

    Martin Esteban Zurita on 05 Jul 2020 22:57:10

    RE: Improve the Advanced Query Editor

    Really needed feature

    Taylor Clark's profile image Profile Picture

    Power BI User 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

    Nick 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

    Rory Neary 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

    Power BI User 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? :)