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.

     

     

Kundan1275's avatar
Kundan1275
Copper Contributor
appreciate your help, but it's now working this way. are you using Microsoft 365?
Adin_Calkic's avatar
Adin_Calkic
Steel Contributor
Apr 30, 2022

Hi Kundan1275 ,

 

try to uninstall/reinstall.

 

yes, I have M365 subscription.

 

 

  • Kundan1275's avatar
    Kundan1275
    Copper Contributor
    Apr 30, 2022
    sure, I'll try this
  • 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