Power Query Problems

Refresh Excel Power Query Data Models on Mac and the Web

Huma Ashraf ChHuma Ashraf Ch Nov 18, 2026 870 views

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.

Refresh Excel Power Query Data Models on Mac and 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.
Before you start

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.

Solution 1Recommended

Refresh the Data Model in Excel for Windows

Use Excel for Windows when the workbook must retain its Data Model, relationships, and dependent reports.

1
Open the workbook in Windows

Open the workbook in the Excel desktop app on a Windows computer with access to the required data sources.

2
Check source credentials

Go to Data > Get Data > Data Source Settings and review permissions or update credentials if prompted.

3
Refresh the workbook

Select Data > Refresh All and wait for the queries and Data Model to finish updating. Review any refresh errors or credential prompts.

4
Save the refreshed file

Select File > Save, then reopen the saved workbook on your Mac or in Excel for the web to view the refreshed results.

Refresh the Data Model in Excel for Windows
Refresh requires source access: Refreshing in Windows still depends on the availability of the data sources, connectors, and valid credentials.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesWork with worksheet tables and spreadsheet reportsUse a familiar interface for a smoother move from Microsoft OfficeAccess a free, lightweight office suite
microsoft office alternative - wps office

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.