Forum Discussion

adishet34's avatar
adishet34
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.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? 

13 Replies

No RepliesBe the first to reply

Resources