We are pleased to announce that the first set of Power Query features are now available in version 16.29 and greater. At this stage you can refresh from text, CSV, XLSX, JSON and XML files.
Refer to the following blog post for more details:
I encourage you to try the new functionality and share your feedback with us via Send a Smile/Frown at the top right corner in your Excel for Mac.
An error occurred while saving the commentSam Johnson commented
We need to be able to work across both PCs and Macs, so our standard applications and tools - including BI - need to work on both. If Power BI isn't going to be implemented on Macs, then we'll have to drop our plans to use it for internal self-service BI - and if it doesn't give us the BI we need, our rationale for sticking with Office365 disappears (Google Docs is much better for collaborative work).