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 commentLee D'Cunha commented
Moved from Excel 2013 for Windows to Excel 2016 for Mac. Very surprised to learn that Mac users do not get full features. Appreciate MS does something about this quick as I need to use distinct count for most of my pivot tables at work.