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]Enrique Macías commented
Please, add Power Apps (Query, Maps & Pivot) to Excel 365 for Mac, it's just unfair that for the same amount of money (in Office 365) you get less content on Mac.