Power Query Function list not displaying

User avatar
chamdan
3StarLounger
Posts: 372
Joined: 17 Dec 2013, 00:07

Power Query Function list not displaying

Post by chamdan »

Hi,

I am using Excel 2016 and when typing a function name normally it should list the function available, in my case it does not. Is there a way to make it to list them like the example I have here enclosed below?
FunctionNames.GIF
You do not have the required permissions to view the files attached to this post.

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Power Query Function list not displaying

Post by Rudi »

The autocomplete lists are a fairly new feature in PQ.
20191219_462.jpg
My version (where the autocomplete is working) is:
2.75.5649.941 32-bit

What version are you using?

You can check the version under DATA > GET DATA > QUERY OPTIONS
In the dialog, select DIAGNOSTICS on the left panel.
20191219_463.jpg
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
chamdan
3StarLounger
Posts: 372
Joined: 17 Dec 2013, 00:07

Re: Power Query Function list not displaying

Post by chamdan »

Hi Rudi,

my version is: 2.75.5649.941 32-bit

It is the same version you are using, so what is different or can be set to allow the auto complete?

Regards,

Chuck

User avatar
chamdan
3StarLounger
Posts: 372
Joined: 17 Dec 2013, 00:07

Re: Power Query Function list not displaying

Post by chamdan »

Hi Hans,

I guess Rudy is on Vacation since he did not respond to my question and look forward from to let me know whether there is any particular setting that I should be doing in order to have the auto-complete list when typing in the formula? On the other hand I would like to wish you all at Eileen's lounge a merry Christmas and a happy new year.

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Power Query Function list not displaying

Post by Rudi »

My apologies for a late reply. I have no idea why you are not getting these autocomplete lists?
I'll see if I can dig up some reasons or find a solution and let you know.

Cheers :cheers:
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
chamdan
3StarLounger
Posts: 372
Joined: 17 Dec 2013, 00:07

Re: Power Query Function list not displaying

Post by chamdan »

:thankyou: Rudy, I look forward to your message.

Chuck

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Power Query Function list not displaying

Post by Rudi »

Hi,

Please check in your query settings if the feature is actually active...
20191223_27.jpg
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
chamdan
3StarLounger
Posts: 372
Joined: 17 Dec 2013, 00:07

Re: Power Query Function list not displaying

Post by chamdan »

Query Options.GIF
You do not have the required permissions to view the files attached to this post.

User avatar
chamdan
3StarLounger
Posts: 372
Joined: 17 Dec 2013, 00:07

Re: Power Query Function list not displaying

Post by chamdan »

Rudy,
Can you check if the Build is the same as yours? Here is mine:
Build.GIF
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78233
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Power Query Function list not displaying

Post by HansV »

I have the same build as you, Chuck, and I don't have that option either...
Best wishes,
Hans

User avatar
chamdan
3StarLounger
Posts: 372
Joined: 17 Dec 2013, 00:07

Re: Power Query Function list not displaying

Post by chamdan »

This is really weird that Microsoft does not have for the same version some consistence in the screen lookup and functions. I even tried to update but it says you're up-to-date. :bash: :xsad:

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Power Query Function list not displaying

Post by Rudi »

My version is similar to yours.
20191223_28.jpg
If you click on the "About Excel" button, this is the details. Is yours similar?
20191223_29.jpg
I'm not sure what more to suggest?
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Power Query Function list not displaying

Post by Rudi »

Hi,
Are you actually on Office 365. According to the below article, intellisense is only available on Office 365.

Quote from: https://www.excelguru.ca/blog/2019/07/1 ... -in-excel/" onclick="window.open(this.href);return false;
How do you get these features?
First, you'll need to be on Office 365. Sorry Excel 2016 and 2019, but my understanding is that these new features are only coming to subscription users. (That's another reason that - in my opinion - you should never buy another 4 digit numbered release of Excel ever again.)

If you are on subscription, you get them with your regular updates. This feature set hit the Insider build channel last month in version 1907. It's currently also been deployed to those on the Monthly Targeted channel running version 1907, build 11901.20080 or newer.

If you're not on the Monthly Targeted channel, you'll need some patience, as it's coming. Just keep checking those updates!
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
chamdan
3StarLounger
Posts: 372
Joined: 17 Dec 2013, 00:07

Re: Power Query Function list not displaying

Post by chamdan »

So Rudy are you on Office 365?

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Power Query Function list not displaying

Post by Rudi »

Yes.
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

jstevens
GoldLounger
Posts: 2617
Joined: 26 Jan 2010, 16:31
Location: Southern California

Re: Power Query Function list not displaying

Post by jstevens »

Is it possible that being offline vs online with Office 365 may have something to do with this type of behavior?

Just my 2 cents.
Regards,
John

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Power Query Function list not displaying

Post by Rudi »

I don't think that is the case. Office 365 has the feature (whether on or offline). The non-subscription versions do not have the intellisense (according to Ken Puls!).
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

User avatar
chamdan
3StarLounger
Posts: 372
Joined: 17 Dec 2013, 00:07

Re: Power Query Function list not displaying

Post by chamdan »

The Office Professional 2016 is the one I have. Let's hope that Microsoft will integrate this fix in their future updates.

Thanks Rudy and Merry Christmas and Happy new year.

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Power Query Function list not displaying

Post by Rudi »

TX. Have a great Xmas and New Year too. Cheers!
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.