Forum Discussion

Rahul_SC's avatar
Rahul_SC
Icon for Helper IV rankHelper IV
4 years ago
Solved

Power query not guiding about function

Hi,   while writing M code in power query inside excel, it does not show related function as per what we are typing, but inside power bi, it does. Why is it so ? is there any option that I need to ...
Need Help
Tips and Tricks
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Yes, Intellisense option is available only in Excel 365 i.e. only in subscription versions of Excel (not in Excel 2019 which is non-subscription version). 

Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Open PQ in Excel - File - Options & Settings - Query Options and see if below is checked. If not, check it. If checked, uncheck it and recheck again.

Close PQ and open again.

  • Rahul_SC's avatar
    Rahul_SC
    Icon for Helper IV rankHelper IV
    4 years ago

    Hi Vijay_A_Verma ,

     

    This option is not available in my excel. I am using 2019 version of excel.

     

     

    • Vijay_A_Verma's avatar
      Vijay_A_Verma
      Icon for Most Valuable Professional rankMost Valuable Professional
      4 years ago

      Yes, Intellisense option is available only in Excel 365 i.e. only in subscription versions of Excel (not in Excel 2019 which is non-subscription version).