Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
monojchakrab
Resolver III
Resolver III

intellisense for power query editor

does power query editor in excel not have the autocomplete feature? I am not able to use any intellisense at all when working with power query in Excel (not BI)

3 ACCEPTED SOLUTIONS
Greg_Deckler
Super User
Super User

@monojchakrab The Advanced Editor in Power Query for Excel has autocomplete/intellisense.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Vijay_A_Verma
Super User
Super User

Like Excel, press Tab to complete the suggestion of Intellisense.

View solution in original post

monojchakrab
Resolver III
Resolver III

5 REPLIES 5
monojchakrab
Resolver III
Resolver III

yes @Greg_Deckler . Thanks

Vijay_A_Verma
Super User
Super User

Like Excel, press Tab to complete the suggestion of Intellisense.

hello, doesn't work at least in excel 2016

Greg_Deckler
Super User
Super User

@monojchakrab The Advanced Editor in Power Query for Excel has autocomplete/intellisense.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Hi Greg

 

Do you know if Intellisense is available on Office Professional Plus 2019?  I've been downtools for the last couple hours trying to find an answer, including talking with Microsoft Support who couldn't help.


Below is extract of the post I just typed out for Power BI forum where Microsoft agent told me to post - long story short couldn't even post the question there.

 

Issue:

The issue is I am trying to build in Power Query but get no suggestions in Fx function box, or anywhere else within Power Query, when I type out my function/formula.  

 

Checked so far:

- Looked around online but can't see anywhere that says whether this is a version issue or product issue - like, for example, it's only avaiable via Office 365 or something.  This would be odd though since Power Query itself is available in Professional Plus.

- Updated to the latest version of Office

- Look in Power Query options for M Intellisense, but no option to check.

 

I'm at a loss at this point, please can somebody offer a solution or answer?

 

image.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors