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

Amy Schalla on 08 Sep 2024 21:32:56

RE: Fix Power Query Intellisense

I completely agree 👍 we need this now 😁

Wyn Hopkins's profile image Profile Picture

Douglas Richards on 08 Sep 2024 19:06:56

RE: Fix Power Query Intellisense

Yes, thank you for bringing this to a vote.

Wyn Hopkins's profile image Profile Picture

Siddharth Rout on 08 Sep 2024 17:55:58

RE: Fix Power Query Intellisense

Completely with you on this! Upvoted.

Wyn Hopkins's profile image Profile Picture

Sérgio Torrinha on 08 Sep 2024 13:46:54

RE: Fix Power Query Intellisense

I couldn't agree more on this one.hopefully Power Query development team can get some ideas from VS code intellisense. There, it works perfectly, at least for Python and SQL (these are the programming languages I work the most. Haven't tested others, but I'm assuming they work equally well given VS code popularity).Thank you.

Wyn Hopkins's profile image Profile Picture

Celia Alves on 08 Sep 2024 13:19:50

RE: Fix Power Query Intellisense

Agreed 100%The current behavior is very disruptive. Thank you for posting this, Wyn!

Wyn Hopkins's profile image Profile Picture

Peter Compton on 08 Sep 2024 04:54:38

RE: Fix Power Query Intellisense

Fully agree. One of my biggest issues is intelligence guessing what you want, and almost always getting it wrong. It always replaces Text.Start with some function I never use!

Wyn Hopkins's profile image Profile Picture

Andre Fomin on 06 Sep 2024 22:36:14

RE: Fix Power Query Intellisense

Makes sense even if you don't think about it...

Wyn Hopkins's profile image Profile Picture

Jeffery Decker on 15 Nov 2023 16:16:38

RE: Fix Power Query Intellisense

There are plug-ins for Notepad++ and Visual Studio Code and probably other editors, but it would be more convenient to have it in the "Advanced" editor.

Wyn Hopkins's profile image Profile Picture

Todd Chittenden on 08 Sep 2021 12:12:35

RE: Fix Power Query Intellisense

They do have Intellisense for M / Power Query, but it is as buggy as a trucker's windshield. I tried to bring this up at the Community Forum but not getting a lot of traction:

Power Query Intellisense not working well - Microsoft Power BI Community

Merged Idea (1)