Refresh a power query
Allow Mac users to refresh a Power Query that gets files from a folder (and was created with windows).
Ashish Mendiratta commented
Importing data from other workbooks, using power query and then analyzing data using power pivot are the critical features needed by professionals for any data analysis. I got very disappointed after shifting to Macbook and paying of office 365 and not getting access to. these functionalities in excel. This is taking macbook users for a ride, though we are paying full for the MS office and not using it for free. I RECOMMEND EVERY MAC USER TO VOICE DISSENT FOR NOT GETTING ACCESS TO ALL FEATURES OF MS OFFICE DESPITE PAYING FULL PRICE.
Mark Longstreath commented
Allow Mac users to refresh a power query that draws info from a web based file too!
In particular, when the files are on SharePoint Online, such as a .CSV or .XLSX file. The latest Excel for Mac can refresh from Text, CSV, XLSX, XML and JSON files, but not when those files are on SharePoint (or other cloud storage locations).