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 commentJoshua Hester commented
This is definitely a step in the right direction, but in an office that uses both PC and Mac, we still cannot use Get & Transform until all data sources are supported and all query editing features are available in Excel for Mac. Please provide an update on the current status of this feature and when the full functionality will be available!Joshua Hester supported this idea ·