Refresh data using Power Query’s From Folder connector in Excel for Mac

(Originally posted July 23, 2024 By ~ I’m going to go)

Hello, Microsoft 365 Insiders! I’m Gal Zivoni, a Product Manager on the Excel team. I’m excited to announce that you can now refresh your data using the From Folder connector in Power Query in Excel for Mac!

Refresh data using the From Folder connector in Power Query in Excel for Mac

Power Query is a powerful, time-saving suite of Excel tools that helps you quickly and easily get, shape, and refresh your data. Over the past few years, we’ve continued to add features to Power Query in Excel for Mac, including: Importing data from a SQL Server databaseMany of you have also told us that you would like the ability to refresh data from a folder source.

We heard you, now you can too!

How it works

1. Open an existing Excel worksheet that contains a report that pulls data from a folder using Power Query.
2. To refresh all reports, select: data > Refresh all.

   Refresh all report data in Excel for Mac

3. Or you can choose: data > Refresh Get the latest data from the folder source.

Tips and Tricks

effectiveness

This feature is rolling out to Mac Beta Channel users running version 16.86 (Build 24051217) or later.

Not yet? It’s probably us, not you.

Features are released over time to ensure everything works smoothly. They are released slowly to a larger number of Insiders, highlighting features you may not have. Sometimes we remove elements based on your feedback to make them even better. This is rare, but we also have the option to completely remove a feature from the product, even if you, as an Insider, had the opportunity to try it out.

feedback

We want to hear from you! Click here help >feedback Please submit your feedback for this feature.

Learn about Microsoft 365 Insider Program And join us Microsoft 365 Insider Newsletter Get the latest Insider features straight to your inbox once a month!