Forum Discussion

Kundan1275's avatar
Kundan1275
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's avatar
    Adin_Calkic
    Apr 30, 2022

    Hi Kundan1275 ,

     

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

     

     

Adin_Calkic's avatar
Adin_Calkic
Steel Contributor

Hi Kundan1275 ,

 

try to uninstall/reinstall.

 

yes, I have M365 subscription.

 

 

Jaitaps's avatar
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's avatar
    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.

     

     

    • Jaitaps's avatar
      Jaitaps
      Copper Contributor
      Jul 01, 2022
      JimGMac Thanks for your prompt reply. Unfortunately, for me only 3 options i.e. From text, from HTML and from database is available which is not resolving my purpose. Basically i wanted to link a database from a website into excel and all the tutorials on youtube show either power query or from table as the option to do the same. is there any way i can do this in my excel?

Resources