SOLVED

Power Query not loading functions

Copper Contributor

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

@adishet34 

Is that option enabled

image.png

and do you type with "=" sign?

image.png

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

 

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

@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

best response confirmed by adishet34 (Copper Contributor)

@SergeiBaklan 

 

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.

@adishet34 

Yes, all latest functionality is on 365, better to use it. You are welcome.

power query.pngas you see Mr Sergi i don't have formula part! what i do ?

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 

 

@doronhagag 

On which exactly channel, version and platform you are? That's in File->Account

image.png

@SergeiBaklan 

 

HI Sergei

 

Attached are screenshots

 

Thank you

 

doronhagag_1-1691440534764.png

 

doronhagag_0-1691440487396.png

 

 

 

Hi sergei,

did you manage to understand the problem?

Thanks Doron

@doronhagag 

Sorry, I missed your previous reply. Unfortunately I don't know the answer. In general such subscription shall have M intellisense. However, perhaps there are some limitation for local versions.

I'd recommend to ask same question on answers.microsoft.com, they are more close to the support. Or, if you have such option, ask support directly. If you ask above please mention you platform (Windows, Mac), subscription type and channel on which you are. Plus on which locale you are.

Sorry again for having no answer.

1 best response

Accepted Solutions
best response confirmed by adishet34 (Copper Contributor)