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
    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

      • Adin_Calkic's avatar
        Adin_Calkic
        Steel Contributor

        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.

         

         

         

    • 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.

Resources