Power query for Mac

[Kundan1275]

In my MS excel, the GET DATA power query button missing, how can I get it please help

[#2 · Accepted solution]

Hi @Kundan1275 ,

Make sure your Excel is up to date. Data Query should be in Data tab. see below.

[#3]

@Adin_Calkic Thank you for your response, I'm using version 16.62, which is the latest, but there is no power query

[#4]

Hi @Kundan1275 ,

Try to see if there is a option in properties. If you can't find it - you probably have different subscription.

Switch to all commands, if you see it you can move to the right.

[#5]

appreciate your help, but it's now working this way. are you using Microsoft 365?

[#6]

Hi @Kundan1275 ,

try to uninstall/reinstall.

yes, I have M365 subscription.

[#7]

sure, I'll try this

[#8]

Your screen shot is of Microsoft Excel 2016, not Office 2021 beta. You must open the current version of Excel to see the PowerQuery features.

[#9]

Hi. Even though i have installed the latest version available for excel i.e. 16.62 but still i can't find the power query in the data tab. There is a tab of Get external data but i can't import data from a URL as the option of the same is not there. pls help

@JimGMac 

[#10]

Hi. Even though i have installed the latest version available for excel i.e. 16.62 but still i can't find the power query in the data tab. There is a tab of Get external data but i can't import data from a URL as the option of the same is not there. pls help

[#11]

@Jaitaps The latest beta channel version is 16.64.  Here is a screen shot of the connectors available to SOME beta channel testers. Keep in mind that not all beta channel testers are provided with every new feature as it is being tested. There is usually a control group that does not get the new features.