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.
Finally the update is live, but I'm unable to figure out how can i fetch data from an Odata source using the new functionality. Also, I'm unable to figure out what's new in this update.
When can we expect this update for all Mac users? My organisation does not allow me to enrol into the insiders program
Can PowerQuery be used to fetch data from OData V4 services??
Can you provide a date by which we can expect OData support for Excel in Mac??Shivam Sharma supported this idea ·