Forum Discussion

Copper Contributor

Apr 30, 2022

Solved

Power query for Mac

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

Adin_Calkic
Apr 30, 2022
Hi Kundan1275 ,

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

Steel Contributor

Apr 30, 2022

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.

Copper Contributor

Apr 30, 2022

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

Adin_Calkic
Steel Contributor
Apr 30, 2022
Hi Kundan1275 ,

try to uninstall/reinstall.

yes, I have M365 subscription.
- Jaitaps
  Copper Contributor
  Jun 30, 2022
  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
    MVP
    Jun 30, 2022
    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.
- Kundan1275
  Copper Contributor
  Apr 30, 2022
  sure, I'll try this

Resources