Troubleshoot Slow Excel Power Query Loads to the Data Model
Question details
Determine why a small Power Query takes much longer to load into the Excel Data Model than to refresh.

- 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.
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.
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.
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.
Right-click the query in Queries & Connections and select Refresh. Record how long it takes for the worksheet load to finish.
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.
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.

Isolate the query and inspect the Data Model
Use this approach when loading to the Data Model is slower than loading to a worksheet.
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.

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.




