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.Bruce supported this idea ·
An error occurred while saving the commentBruce commented
I am using Office 365 for Mac. My work includes building Business Analysis Models for my customers and it is really problematic for me that this functionality does not exist. Could you tell me where the fix sits in the planned product release schedule?