Forum Discussion
Power Query not loading functions
- May 15, 2021
"That feature is available on 365 only, sorry."
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.
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, 2021Diamond Contributor
"That feature is available on 365 only, sorry."
- adishet34May 15, 2021Copper Contributor
I guess it's an Excel version issue after checking with two other systems with Office 365.
It is just mind-boggling that, I have a power query but to get just formulas automatically loaded while typing, I have to change the Excel version.
Thank you for providing a quick input on my query.