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 commentSebastian commented
More than half a year since the announcement that we can now refresh queries created in Mac on Windows, there is still no timeline, when we can create Queries in Excel on Mac. At least a rough timeline would be a nice gesture, as this feature has a history of five years.
Thanks for this suggestion. We will monitor the votes here and consider this suggestion along with the other requests.
Steve K [MS Excel]