Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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)
Solved! Go to Solution.
@monojchakrab The Advanced Editor in Power Query for Excel has autocomplete/intellisense.
Like Excel, press Tab to complete the suggestion of Intellisense.
Like Excel, press Tab to complete the suggestion of Intellisense.
hello, doesn't work at least in excel 2016
@monojchakrab The Advanced Editor in Power Query for Excel has autocomplete/intellisense.
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?