Forum Discussion

Copper Contributor

May 14, 2021

Solved

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.CurrentWork...

Formulas and Functions

SergeiBaklan
May 15, 2021
adishet34

"That feature is available on 365 only, sorry."

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_2019/intellisense-in-power-query-excel-2019/d56e1dd6-fb80-497b-9775-0350834377f5

Diamond Contributor

May 15, 2021

Is that option enabled

and do you type with "=" sign?

Mokhtar370
Copper Contributor
Mar 02, 2022
as you see Mr Sergi i don't have formula part! what i do ?
- doronhagag
  Copper Contributor
  Aug 05, 2023
  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
  - SergeiBaklan
    Diamond Contributor
    Aug 07, 2023
    doronhagag
    
    On which exactly channel, version and platform you are? That's in File->Account
adishet34
Copper Contributor
May 15, 2021
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
  Diamond Contributor
  May 15, 2021
  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.
  - adishet34
    Copper Contributor
    May 15, 2021
    SergeiBaklan
    
    I have attached the screenshot of my Excel version. If anybody can clarify if it is specific to the version or some options that must be enabled, would be a great help. I couldn't find much from other sources regarding this issue.
    
    Thank you

Resources