Power Query Problems

Troubleshoot Slow Excel Power Query Loads to the Data Model

Khadija KhanKhadija Khan Nov 18, 2026 868 views

Question details

Determine why a small Power Query takes much longer to load into the Excel Data Model than to refresh.

Troubleshoot Slow Excel Power Query Loads to the Data Model
Product
Microsoft Excel Power Query and Data Model
Device & OS
not provided
Scenario
A user refreshes a small query and loads its results into the workbook's Data Model.
Observed behavior
The query refreshes quickly, but loading it to the Data Model takes much longer, even when there are no visible measures or relationships.
Before you start

Open the workbook in Excel and identify the slow query in Data > Queries & Connections. Use separate copies of the workbook for load tests so you can compare destinations without changing the original.

Solution 1Recommended

Compare worksheet and Data Model load times

Use this test to determine whether the delay occurs primarily during the query refresh or the Data Model load.

1
Set up a worksheet load

In a workbook copy, open Data > Queries & Connections, right-click the query, and select Load To. Choose Table and clear Add this data to the Data Model.

2
Time the refresh

Right-click the query in Queries & Connections and select Refresh. Record how long it takes for the worksheet load to finish.

3
Test the Data Model load

In a separate copy, right-click the same query, select Load To, and choose Only Create Connection with Add this data to the Data Model selected. Refresh the query and record the time.

4
Compare the results

Compare the two refresh times. If the worksheet load is fast but the Data Model load is slow, investigate model processing and dependencies rather than assuming the query itself is the only cause.

Compare worksheet and Data Model load times
Keep the tests comparable: Use the same source data and query settings in both copies. Existing model contents and other refresh activity can also affect the results.
Free Microsoft Office alternative

Use WPS Spreadsheets for Everyday Excel Workbook Tasks

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface for working with compatible Excel files. It can help with everyday workbook editing, but it does not fix Excel Power Query or Data Model processing delays.

Open and edit compatible Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface for everyday workbook tasksWork with worksheet tables without relying on an Excel Data ModelMove common spreadsheet work to a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why can a small query refresh quickly but load slowly to the Data Model?

The query refresh and the Data Model load involve different work. Model processing, dependencies, calculated columns, or other workbook contents may contribute to the delay. Compare worksheet-only and Data Model loads to narrow it down.

How do I load a query to a worksheet instead of the Data Model?

In Data > Queries & Connections, right-click the query and choose Load To. Select Table and clear Add this data to the Data Model, then refresh the query.

Can I remove other queries to test the slow one?

Yes. In a workbook copy, remove unrelated queries through Data > Queries & Connections, but retain any queries required by the one being tested. Check Query Dependencies first if that view is available.

Where can I check calculated columns and relationships?

Open Power Pivot > Manage, if available, to inspect model tables and calculated columns. You can also review relationships in the model or through Excel's Data > Relationships command.