Journey to Power Query in Excel for Mac continues

(Originally published on October 20, 2020 by Guy Hunkin)

Hello again! I’m Guy, a Program Manager on the Excel team. I’m here today to share some exciting news about our journey to bring Power Query in Excel for Mac. With the recent update, even more of your data refresh scenarios are now supported!

Power Query in Excel

Power Query is a powerful and time-saving set of tools to gather and analyze data quickly and easily. Bringing Power Query capabilities to Excel for Mac remains one of the top customer asks. In addition, we get a lot of positive feedback from you and excitement every time we release a new update!

We’re announcing a series of great enhancements to data refresh capabilities. Specifically, you can now refresh your Power Query queries on Mac from the following important and frequently used online data sources – files on SharePoint, SharePoint Lists, SharePoint Folder and OData.

With the data refresh capabilities announced earlier this year (May and July announcements), you now have a solid set of popular data sources that you can refresh your Excel reports from.

Update! You can now import data from local using Power Query. Check out the Excel team's post to learn more.

How it works

1. To automatically refresh your reports that pull data from files on SharePoint, SharePoint Lists, SharePoint Folder and OData, click Data > Refresh All.

   Refresh All in Excel ribbon

2. The first time you access the SharePoint or OData, you’ll be prompted to enter the login credentials. You may choose the required method of authentication (including your organizational account) from the dropdown.

   Credential prompt

3. To remove the existing login credentials, click Data > Connection > Clear Permissions.

Availability

This feature is available to Insider running Mac Version 16.41 (20091302) or later.

We typically release features over some time to ensure that things are working smoothly. This is true for Insiders as well. We highlight features that you may not have because they’re slowly releasing to larger numbers of Insiders. Sometimes we remove elements to further improve them based on your feedback. Though this is rare, we also reserve the option to pull a feature entirely out of the product, even if you, as Insiders, have had the opportunity to try them.

Feedback

We want to hear from you! Click the Feedback button near the top-right corner in Excel on Mac to provide your thoughts about this feature. Add #PowerQuery in your feedback so that we can find it easily.

Learn about the Microsoft 365 Insider program and sign up for the Microsoft 365 Insider newsletter to get the latest information about Insider features in your inbox once a month!