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.
Thanks for your comments and votes supporting this issue. We will continue to monitor this topic.
Thanks – Steve K [MS Excel]
An error occurred while saving the commentAnonymous commented
I cannot comprehend why this is still being asked for.
ITS BEEN ALMOST 5 YEARS SINCE THE ORIGINAL COMMENT WAS MADE.
There is not a single person on the planet that could ever convince me that this is a difficult request to fulfil. So why make a super useful, but due to its abilities somewhat cluttered application, used the world over painful for a large quantity of its users..