Hi all! We have recently extended the list of supported sources you can refresh your Power Query queries from in Excel for Mac. In addition to refreshing your data from Text, CSV, JSON and XML files, you can now refresh your data from the tables and ranges in the current workbook, as well as from SQL Server database. For more information about Power Query features that are currently supported in Excel for Mac, please take a look at the following support article:
Principal Product Manager, Excel Team
Thanks for your support for this issue. While we do have it on our to-do list, we don’t expect to add this in the short-term, so we’re marking it Not at this time. We’ll continue to monitor the votes on it.
An error occurred while saving the commentBri commented
Any updates on if this will be added for Mac soon? It's been almost 3 years since the last update.