Any workarounds available to avoid having to have a Windows OS to be needed?.Can Microsoft provide transparancy regarding their roadmap? What can we expect by when - and what not?.

Hoping I can get more details on things such as: Seeing as this was stated somewhere in 2019 it does make me curious to understand where Microsoft stands now in regards to further rolling out this functionality for MacOS. Looking at the amount of users voted for getting this feature fully supported on MacOS I am confident this is something that is continuously being worked on by Microsoft. Spending a week on researching the internet learned this functionality is not - yet - available for MacOS.įrom what I have been able to learn, the newest Excel 365 does offer the option to refresh existing queries - queries created on a Windows machine, though also learned according to Microsoft this is rather 'phase 1' and we should expect more to come.

More or less immediately ran into issues when trying to find the Get & Transform functionality on the MacOS - it simply was not there. Recently switched over from Windows to MacOS, not knowing the versions of Excel 365 for both the OSes are not the same.

Power query mac 2021