Forum Discussion
adishet34
May 14, 2021Copper Contributor
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...
- May 15, 2021
"That feature is available on 365 only, sorry."
SergeiBaklan
May 15, 2021MVP
adishet34
May 15, 2021Copper Contributor
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.
- SergeiBaklanMay 15, 2021MVP
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.
- adishet34May 15, 2021Copper Contributor
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
- SergeiBaklanMay 15, 2021MVP
"That feature is available on 365 only, sorry."