Skip to main content

    Data Factory

    Needs Votes

    Fix Power Query Intellisense

    Vote (192) Share
    Wyn Hopkins's profile image

    Wyn Hopkins on 08 Sep 2024 01:13:39

    its well known that intellisense has always been broken with things like ListList.Contains


    or pressing . after typing certain prefixes does not correctly show options, or typing null enter puts null.type in.


    Also a huge issue is no intellisense in Dataflows


    both need fixing

    Administrator on 09 Sep 2024 18:11:15

    Update 9/9/2024: We've merged similar ideas around needing Intellisense in Power Query into a single idea. We have no plans of making any investements in the legacy Power Query UI, but the new modern Power Query UI found within Power Qury Online (Dataflow) can pursue this enhancement. The modern Power Query UI will ship inside of all products where Power Query is present today such as Power BI Desktop and Excel for Desktop.

    Comments (19)
    Wyn Hopkins's profile image Profile Picture

    Raymond Boone on 15 Oct 2024 21:57:13

    RE: Fix Power Query Intellisense

    This truly makes me crazy every time I work in Power Query.

    Wyn Hopkins's profile image Profile Picture

    Grainne Duggan on 29 Sep 2024 20:56:34

    RE: Fix Power Query Intellisense

    Please fix it in desktop Excel. It has been broken way too long!

    Wyn Hopkins's profile image Profile Picture

    Rick de Groot on 13 Sep 2024 21:30:40

    RE: Fix Power Query Intellisense

    We do need this. Please develop this :)!

    Wyn Hopkins's profile image Profile Picture

    on 09 Sep 2024 18:05:06

    RE: Fix Power Query Intellisense

    It would really be awesome to have built-in intellisense for M language as we have for DAX.

    Wyn Hopkins's profile image Profile Picture

    on 09 Sep 2024 17:48:47

    RE: Fix Power Query Intellisense

    Collaborative work through dataflows has increased, it is quite hard to write M scripts without Intellisense in PQ Online, though. Is there something on the horizon to come up with a solution for that?

    Wyn Hopkins's profile image Profile Picture

    on 09 Sep 2024 17:48:47

    RE: Fix Power Query Intellisense

    One of the things that I like about using the Power BI desktop is that you are able to use the syntax highlighting & snippets / IntelliSense built into the advanced editor. Recently, after working with data flows it has become difficult because the syntax highlighting and IntelliSense doesn't exist on the online version. If this was added like as is on desktop, it would probably save a lot of time for some people from copying from a text editor over to the online app. Even if it was not IntelliSense and just snippets instead, it would make writing queries much easier still.

    Wyn Hopkins's profile image Profile Picture

    on 09 Sep 2024 17:48:47

    RE: Fix Power Query Intellisense

    Hi,

    The intellisense is a welcome addition to Power BI. However, it seems to work only in the Advanced Editor window. Is there any plan on extending this out to the Custom Column feature in the GUI ?

    Wyn Hopkins's profile image Profile Picture

    on 09 Sep 2024 17:48:47

    RE: Fix Power Query Intellisense

    Intellisense is great, but why not for functions? It would be great to have it also in Excel PowerQuery

    Wyn Hopkins's profile image Profile Picture

    Cristian Prifti on 09 Sep 2024 10:01:35

    RE: Fix Power Query Intellisense

    This is by a far a huge inconsistency, hopefully it will get a fix soon. Dataflows are a nightmare for a new Power BI user from this perspective :)

    Wyn Hopkins's profile image Profile Picture

    Atikant Jain on 09 Sep 2024 09:33:17

    RE: Fix Power Query Intellisense

    Absolutely agree with this!

    Merged Idea (1)