SOLVED

Power Query not loading functions

%3CLINGO-SUB%20id%3D%22lingo-sub-2354676%22%20slang%3D%22en-US%22%3EPower%20Query%20not%20loading%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2354676%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20using%20MS%20Office%20Home%20%26amp%3B%20student%202019.%20I%20want%20to%20transform%20the%20data%20from%20my%20current%20workbook.%20I%20open%20the%20Power%20Query%20editor%20as%20a%20Blank%20query%20and%20while%20typing%20the%20function%20%22Excel.CurrentWorkbook%22%20in%20the%20formula%20bar%2C%20the%20functions%20don't%20show%20up%20as%20I%20type.%20Instead%2C%20I%20have%20to%20type%20it%20manually%20keeping%20in%20mind%20it's%20case%20sensitive.%20Once%20I%20type%20the%20function%2C%20it%20will%20ask%20to%20Invoke%20parameters%20and%20then%20it%20gets%20the%20data%20from%20the%20current%20workbook.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anybody%20please%20help%20me%20with%20resolving%20this%20issue%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2354676%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2356918%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20not%20loading%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2356918%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1053876%22%20target%3D%22_blank%22%3E%40adishet34%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20that%20option%20enabled%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20626px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F280851iFFBA15ECD350F26F%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eand%20do%20you%20type%20with%20%22%3D%22%20sign%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20593px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F280852i89FA8AC0A678514C%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2356962%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20not%20loading%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2356962%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Sergei%2C%3C%2FP%3E%3CP%3EThank%20you%20for%20responding%20to%20my%20query.%3C%2FP%3E%3CP%3EThe%20option%20to%20enable%20the%20%22M%20intellisense%22%20is%20missing%20in%20my%20Excel%20query%20options.%20I%20have%20attached%20the%20screenshot.%3CBR%20%2F%3EI%20did%20start%20the%20formula%20with%20%22%3D%22%20operator%2C%20but%20still%20no%20changes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2357000%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20not%20loading%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2357000%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1053876%22%20target%3D%22_blank%22%3E%40adishet34%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%26nbsp%3B%3CSPAN%3Eintellisense%20is%20missing%20when%20it's%20nothing%20to%20do%20with%20that.%20Sorry%2C%20I%20don't%20know%20shall%20it%20be%20available%20for%202019%20or%20not%20and%20on%20which%20versions.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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? 

7 Replies

@adishet34 

Is that option enabled

image.png

and do you type with "=" sign?

image.png

@Sergei Baklan 

 

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.

@Sergei Baklan 

 

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 (New Contributor)

@Sergei Baklan 

 

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.