Forum Discussion

Copper Contributor

Apr 30, 2022

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

Hi Kundan1275 ,

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

Copper Contributor

Apr 30, 2022

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

Adin_Calkic
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.
- Kundan1275
  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.
JimGMac
MVP
May 28, 2022
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.
- 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

Share

Resources