Forum Discussion

adishet34's avatar
adishet34
Copper Contributor
May 14, 2021

Power Query not loading functions

Hi,

 

I'm using MS Office Home & student 2019. I want to transform the data from my current workbook. I open the Power Query editor as a Blank query and while typing the function "Excel.CurrentWorkbook" in the formula bar, the functions don't show up as I type. Instead, I have to type it manually keeping in mind it's case sensitive. Once I type the function, it will ask to Invoke parameters and then it gets the data from the current workbook. 

 

Can anybody please help me with resolving this issue? 

    • Mokhtar370's avatar
      Mokhtar370
      Copper Contributor

      as you see Mr Sergi i don't have formula part! what i do ?

      • doronhagag's avatar
        doronhagag
        Copper Contributor

        i have tha same problem, and i have the last version of office 365

         

        I also can't find an answer to the problem all over the internet, really strange

         

        Mokhtar370 

         
    • adishet34's avatar
      adishet34
      Copper Contributor

      SergeiBaklan 

       

      Hi Sergei,

      Thank you for responding to my query.

      The option to enable the "M intellisense" is missing in my Excel query options. I have attached the screenshot.
      I did start the formula with "=" operator, but still no changes.

       

      Thank you.

       

      • SergeiBaklan's avatar
        SergeiBaklan
        MVP

        adishet34 

        If intellisense is missing when it's nothing to do with that. Sorry, I don't know shall it be available for 2019 or not and on which versions.

Resources