Refresh Excel Power Query Data Models on Mac and the Web
Question details
The user needs to refresh Power Query queries loaded to an Excel Data Model when working on a Mac or in Excel for the web.

- Product
- Microsoft Excel Power Query and Data Model
- Device & OS
- macOS and Excel for the web
- Scenario
- A workbook uses Power Query to load data into a Data Model and needs updated data.
- Observed behavior
- Excel for Mac does not support refreshing queries loaded to the Data Model, and Excel for the web may also fail to refresh this configuration.
Identify whether the queries are loaded to the Data Model and whether PivotTables or relationships depend on it. Check that you have access to the data sources and their credentials before attempting a refresh.
Refresh the Data Model in Excel for Windows
Use Excel for Windows when the workbook must retain its Data Model, relationships, and dependent reports.
Open the workbook in the Excel desktop app on a Windows computer with access to the required data sources.
Go to Data > Get Data > Data Source Settings and review permissions or update credentials if prompted.
Select Data > Refresh All and wait for the queries and Data Model to finish updating. Review any refresh errors or credential prompts.
Select File > Save, then reopen the saved workbook on your Mac or in Excel for the web to view the refreshed results.

Load query results to a worksheet instead of the Data Model
Use this approach if the workbook can work without Data Model relationships or reports that depend on them.
Redesign the workbook for supported Mac connectors
Use this option when the workbook needs to refresh on a Mac without relying on the Data Model.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface and support for common Microsoft Office formats, making it easy to move between office suites. It does not fix Excel's Power Query Data Model refresh limitations.

Frequently Asked Questions
Can Excel for Mac refresh a Power Query loaded to the Data Model?
Excel for Mac does not support refreshing queries loaded to the Data Model. Open the workbook in Excel for Windows and use Data > Refresh All, or redesign it without the Data Model dependency.
Can I refresh the workbook in Excel for the web?
Excel for the web supports refresh for some queries, but a workbook with queries loaded to the Data Model may fail to refresh. Test Data > Refresh All and use Excel for Windows if the configuration is unsupported.
What happens if I remove a query from the Data Model?
PivotTables, relationships, and calculations that depend on the Data Model may need to be rebuilt. In Excel for Windows, check the query's destination through Data > Queries & Connections > Load To before changing it.
Will every worksheet query refresh on a Mac?
No. Refresh depends on your Excel version, connector, data source, and query features. Check the options under Data > Get Data and test the query with Data > Refresh All.
Can WPS Office refresh my Excel Power Query Data Model?
WPS Office can open common Excel file formats, but it is not a fix for Microsoft Excel's Power Query Data Model refresh limitation. Use Excel for Windows when the Data Model must be refreshed.




