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

    • Morkus2Office's avatar
      Morkus2Office
      Copper Contributor

      nakovali 

      Nope, I have that latest version but PowerQuery does not give me any button but "LOAD" and "CANCEL".

      • nakovali's avatar
        nakovali
        Copper Contributor

        Morkus2Office 

         

        I had exactly the same problem. I was on the latest version but Excel did not have pq.


        then I maunally downloaded excel 16.64 frol the release notes. The installation file was something like 800 mb. After installing that, I was able turn on new features.

        I hope this helps.

         

        until yesterday I was not even a office insider.

  • Adin_Calkic's avatar
    Adin_Calkic
    Steel Contributor

    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

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

      • JimGMac's avatar
        JimGMac
        MVP
        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.

Resources