Forum Discussion
Power query for Mac
In my MS excel, the GET DATA power query button missing, how can I get it please help
- nakovaliCopper Contributor
I am not sure if you were able to fix it, but I was having the same issue.
Although I was on the latest version was not able to get the new features.
The solution that worked for me was to download the manual latest version from the microsoft. I will put the link below. After installing this package, it worked like a charm
https://docs.microsoft.com/en-us/officeupdates/update-history-office-for-mac
- Morkus2OfficeCopper Contributor
Nope, I have that latest version but PowerQuery does not give me any button but "LOAD" and "CANCEL".
- nakovaliCopper Contributor
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.
- Kundan1275Copper Contributor
nakovali”Power query” for Mac is a bit different so I switched to windows 😂😂
- Adin_CalkicSteel Contributor
- Kundan1275Copper Contributor
Adin_Calkic Thank you for your response, I'm using version 16.62, which is the latest, but there is no power query
- Your screen shot is of Microsoft Excel 2016, not Office 2021 beta. You must open the current version of Excel to see the PowerQuery features.