Power Query for Mac Excel

Question

Hi, is there a way to have Power Query on a Mac Excel (version 16.54, 365 subscription)?

I searched online and noticed it was available from 16.4x beta and up:

1. https://support.microsoft.com/en-us/office/import-data-in-excel-for-mac-power-query-7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5
2. https://answers.microsoft.com/en-us/msoffice/forum/all/power-query-mac-option-get-data-missing/93f65d63-2eda-47c2-b44a-a187b3b7c7dc

Screenshot of what is available on my Data tab:

Screenshot of version:

Any help will be great! Thank you!

Answer 1

Hi A. Tan,

As per your description, based on my test result in Excel version 16.54 (21101001) and I’m able to use Power Query on Mac OS.  See my test image below for your reference:

Since, your Office 365 on your Mac OS is up-to-data and still you are unable to see Power Query option from your side.

Please make sure your file system is OK.  starting by checking file system using Disk Utility. If there are file system problems, Disk Utility may be able to fix them.

How to repair a Mac disk with Disk Utility - Apple Support

Also, please try to operate a safe boot for Mac then the outcome. To operate the safe mode is to determine whether background programs are interfering with Office for Mac.

Disclaimer*: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.*

May I know does issue happened to specific Excel file? if issue with all Excel files even new created Excel document on your Mac OS, then I suspect components were corrupted somehow. You can go to the Applications folder In Finder and drag Microsoft Excel.app to the trash. Then Restart your Mac Download this installer the Install package and use it to reinstall Microsoft Excel (the latest version 16.54). Then, restart your Mac and test.

If above suggestion does not work for you, please feel free to confirm your MacOS version.

I appreciate your understanding and stay safe!!

Best Regards

Waqas Muhammad

Answer 2

Hi A. Tan,

May I know have any updates regarding to this issue? Feel free to post back if you need further assistance.

Best Regards,

Waqas Muhammad

Answer 3

Hi

To join the beta, go to the Excel Help menu and choose Check for Updates

In the resulting AutoUpdate app, click the Advanced button, then change the setting from Current Channel to Beta Channel.