Forum Discussion
Solved
Power query for Mac
In my MS excel, the GET DATA power query button missing, how can I get it please help
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.
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.
It's weird you have different functionality. I guess I need to open a trouble ticket with MS.
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.
- 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.
😞 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.
- I also have a business 365 license.
Let me know how your license, version, installed language, or whatever could be (or is) different.
Thanks,
