Forum Discussion

monojchakrab's avatar
monojchakrab
Resolver III
4 years ago
Solved

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)

Show and Tell
Tips and Tricks

5 Replies

    • Anon_5's avatar
      Anon_5
      New Member
      2 years ago

      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?

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

       

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional
    4 years ago

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