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.

     

     

Morkus2Office's avatar
Morkus2Office
Copper Contributor

There is no "Transform Data" button shown in lower right corner. The only buttons displayed are: "LOAD" and "CANCEL"

 

The Transform data button is totally missing.

I've also tried using the preview channel.

My version of Excel 365 is 16.64 (latest version as of 2022-07-06).

---

Would appreciate any ideas how to get this feature to work without having to start Windows...

JimGMac's avatar
JimGMac
MVP
Jul 07, 2022
Hi again

Is your Mac OS system set to US English? I don't think localizations of the editor have rolled out yet.
  • JimGMac's avatar
    JimGMac
    MVP
    Jul 11, 2022

    Morkus2Office 

     

    The way the beta program works is that new features can be random. Microsoft can set say 10% will get the new feature in any week's beta channel build. Each week when the new build is released you have a shot at getting a new feature. As Microsoft's confidence in having a trouble-free feature increases, the size of the group getting access to the feature is enlarged. There is a web site you can use to track what's officially being released and when. That said, the site tends to document what's new after the feature is open to all beta testers. When I searched for PowerQuery none of the functionality I have is mentioned.

  • Morkus2Office's avatar
    Morkus2Office
    Copper Contributor
    Jul 11, 2022
    Well I was on the regular channel, 16.62, before and it wasn't there, either. I read somewhere that you needed to be in the beta channel to try to get these new features so I tried that, too.

    I guess it's Windows or nothing for many Office 365 features.

    😞
  • JimGMac's avatar
    JimGMac
    MVP
    Jul 10, 2022

    Morkus2Office Version 16.64 is the beta channel build. When it comes to new features, not all beta channel users will see the new feature. Some users get the new feature while the rest is a control group. My install is US English with an E5 enterprise license. Even having all the requirements is no guarantee you will have a new feature while in the beta channel.

  • Morkus2Office's avatar
    Morkus2Office
    Copper Contributor
    Jul 10, 2022
    I also have a business 365 license.
    Let me know how your license, version, installed language, or whatever could be (or is) different.
    Thanks,
  • Morkus2Office's avatar
    Morkus2Office
    Copper Contributor
    Jul 10, 2022
    Yes, I have US English, and the latest version of Excel 365 (16.64). But as I've said above, there is NO Transform data shown. It's just CANCEL LOAD. That's all.
    It's weird you have different functionality. I guess I need to open a trouble ticket with MS.
  • JimGMac's avatar
    JimGMac
    MVP
    Jul 08, 2022

    Morkus2Office 

     

    Transform Data is now available to Office 365 subscribers who have current updates installed. It may require a specific license type and US English as the system language. 

  • Morkus2Office's avatar
    Morkus2Office
    Copper Contributor
    Jul 08, 2022
    Yes.
    Any idea when Transform Data will be available on Mac?
    Thanks

Resources