Hi everyone – There are many comments here asking for PowerPivot, which is being tracked separately. This suggestion is only counting votes for PowerQuery (Get & Transform).
To vote for the PowerPivot suggestion, please go to it – https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/19568977-add-powerpivot-to-mac-excel.
Thanks – Steve K [MS Excel]Jim commented
I use OData regularly to download data from an SAP HANA system. The fact the Excel for Mac does not include this capability is troubling.