Forum Discussion
Missing get and transform data
I'm not familiar with consumer versions. In general on subscription model ( Microsoft 365 ) you always have the latest functionality compare to similar perpetual version. The latest has fixed functionality and updating only bug fixes and security patches.
On Microsoft 365 set of features depends on subscription level and distribution channel. Enterprise has the richest functionality, other levels we have to check.
Distribution channel means how often functionality is updated. On insider (beta) channel you have updates every week, on semi-annual channel - twice per year. Good news you may shift from one channel to another at any time, that's free of charge.
As for Power Query on Personal - most probably it's available, but I'd double check. You may install trial version (one month as I remember), check if that's what you need and only after that pay for the subscription.
I'm not familiar with consumer versions. In general on subscription model ( Microsoft 365 ) you always have the latest functionality compare to similar perpetual version. The latest has fixed functionality and updating only bug fixes and security patches.
On Microsoft 365 set of features depends on subscription level and distribution channel. Enterprise has the richest functionality, other levels we have to check.
Distribution channel means how often functionality is updated. On insider (beta) channel you have updates every week, on semi-annual channel - twice per year. Good news you may shift from one channel to another at any time, that's free of charge.
As for Power Query on Personal - most probably it's available, but I'd double check. You may install trial version (one month as I remember), check if that's what you need and only after that pay for the subscription.
Thank you, nice to know. I guess depends on channel.
SergeiBaklan At present, Excel for Mac (Insider, Beta) supports the following connectors:
From the link you sent on Mac are available only two connectors
All the rest is ability to refresh quires created on another platform. However, I'm not Mac user, perhaps Riny_van_Eekelen could clarify.
- apparently Get and Transform Data from Web feature is not available on M365 for Mac.
https://support.microsoft.com/en-us/office/power-query-data-sources-in-excel-versions-e9332067-8e49-46fc-97ff-f2e1bfa0cb16
Please advise if this is incorrect. It's better to start new conversion from here https://techcommunity.microsoft.com/t5/excel/bd-p/ExcelGeneral. Yes, screenshot will help.
- Hello,
In my excel 365, in data tab,
I have the request connexion group,
But not the get & transform.
Could you please help me?
Can I send a screenshoot?
Regards DanTN123 , you are welcome, good luck with Excel 365
- I got excel 365 personal membership and I can now see the power query stuff.
Thanks a lot, you helped me out a ton 🙂
