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.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?
"That feature is available on 365 only, sorry."
- Mokhtar370Copper Contributor
as you see Mr Sergi i don't have formula part! what i do ?
- doronhagagCopper 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
- adishet34Copper 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.
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.