Thanks for all your comments and votes supporting this suggestion. We are in the planning stages for this feature to be added to Excel for Mac.
Thanks – Steve K [MS Excel]
Thanks for all the votes and comments on this suggestion. We know this is important and it’s a big undertaking. Please continue to show your support for this.
Steve K [MS Excel]Stefano commented
When this will be available? I have Office365 and I need PowerPivot for my job
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.