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.Will commented
There should literally be a class action lawsuit or antitrust action regarding this. We pay the exact same amount but don’t get the same features...unless we buy a Microsoft operating system??? Haven’t you guys already been through the antitrust exercise once? Clearly you haven’t learned your lessons. The fact that multiple features consistently lag or are slightly less convenient, is extremely unethical. Even the filter function sucks on Mac. Come on man!