Skip to main content

Data Factory

Planned

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 19 Nov 2024 19:34:16

Update 11/19/2024: We're working on enabling intellisense in Power Query Online. We will update this idea once we have more information to share, but we are aiming to have a public preview during the first half of the calendar year 2025.

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)