(Originally published on July 23, 2020 by Guy Hunkin)
Hello, I’m Guy, a Program Manager on the Excel team. I’m here today to share some exciting updates to Power Query in Excel for Mac. For instance, we’ve made it easier than ever to refresh your Power Query queries.
Updates to Power Query
When we introduced the Power Query technology in Excel for Mac, we heard from many of you that you loved it! It's a powerful and time-saving set of tools to gather and analyze data quickly and easily.
In addition, we received a lot of feedback requesting the ability to refresh data from additional sources. Today, we're announcing two great enhancements to data refresh capabilities. You can now refresh your Power Query queries on Mac from local tables and ranges, and from Microsoft SQL Server.
Update! You can now import data from local using Power Query. Check out this blog to learn more.
How it works
- To refresh your reports, click Data > Refresh All. Power Query queries that pull data from tables and ranges in your workbook will be automatically refreshed.
- To refresh your SQL queries in your workbook:
- Click Data > Refresh All.
Refresh All in the ribbon
- Upon the first access to the data source, you'll be asked to specify the login credentials. Database level login credentials are currently supported.
- To clear the existing login credentials, click Data > Connection > Clear Permissions.
Availability
This feature is available to Insider Fast users who are running Mac Version 16.35 Build (20022603) 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! Please go to Help > Feedback in Excel to provide your thoughts about this feature. Include #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!