Power Query Problems

How to Prevent Excel Power Query from Downloading SQL Data Again During a Merge

Camila MilosovichCamila Milosovich Nov 13, 2026 869 views

Question details

The user needs to prevent Power Query from re-downloading SQL Server source data when merging smaller workbook datasets against rows already loaded to a PivotTable or Data Model.

How to Prevent Excel Power Query from Downloading SQL Data Again During a Merge
Product
Microsoft Excel Power Query
Device & OS
not provided
Scenario
The user loads about 2 million SQL rows monthly for a PivotTable and needs to merge smaller workbook data with those rows without refreshing the SQL source each time.
Observed behavior
A merge that references a query loaded to a PivotTable or Data Model appears to query SQL Server again because data loaded for a PivotTable is not available as a reusable Power Query record set.
Before you start

Check whether the SQL results are loaded to a worksheet table, PivotTable, or Data Model, and confirm the total row count. Identify a local staging location such as an Excel table, split tables, the Data Model, or a local database before changing the query destination.

Solution 1Recommended

Stage SQL Results in a Local Excel Table Before You Merge

Use this when you need to merge smaller workbook data against the same SQL extract repeatedly without re-querying SQL Server.

Power Query cannot reference data loaded only into a PivotTable or Data Model as a merge source. Staging the SQL output as a table or split tables makes it available for local joins while avoiding worksheet row limits.

1
Duplicate the SQL query

In Excel, go to Data > Queries & Connections, right-click the SQL query, and select Duplicate.

2
Change the destination to a workbook table

Right-click the duplicate query, choose Load To, and select Table. If the result exceeds 1,048,576 rows, choose Only Create Connection or split the data by a column such as region or date.

3
Load the staged result once

Click OK or Load to run the query once. Save the staged table in a dedicated Excel workbook or local file.

4
Point the merge query to the staged table

In Power Query Editor, create the merge from the smaller workbook query to the staged Excel table or connection instead of the SQL Server source.

Stage SQL Results in a Local Excel Table Before You Merge
SQL source refreshed only when staging: The SQL source is refreshed only when you run the staging query, not every time you merge against the staged output.
Free Microsoft Office alternative

Manage Staged Excel Workbooks with a Free, Lightweight Spreadsheet

Power Query merge behavior is part of Microsoft Excel. WPS Office does not replace Power Query's server-side merge capabilities, but it can open, edit, and manage your staged Excel workbooks for free with strong .xlsx compatibility and a familiar interface.

Opens and edits .xlsx workbooks used for staged Power Query merges without an Office subscriptionMaintains formulas, tables, and pivot table layouts for compatible Excel filesLightweight and familiar ribbon interface reduces migration effort from Microsoft ExcelLets you inspect, clean, and share local data extracts before importing them into Power QuerySupports Microsoft Office file formats for smoother collaboration with Excel users
microsoft office alternative - wps office

Frequently Asked Questions

Why does a Power Query merge download SQL data again?

A Power Query merge must access the source through a query. Data loaded only to a PivotTable or Data Model is not exposed as a reusable Power Query record set, so Power Query refreshes the SQL connection before performing the join.

Can Power Query use data already loaded into the Data Model for a merge?

Generally no. Power Query cannot directly reference Data Model or PivotTable-loaded records as a merge source. Stage the SQL output in an Excel table, a local database, or split queries instead.

How do I merge 1.4 million rows if they exceed the Excel worksheet limit?

Use the Data Model, a local database, or split the data into multiple tables or connections. Refresh the SQL query once, then merge against the staged output rather than the original SQL Server source.

Is there a way to avoid the second SQL download entirely?

Yes. Stage the SQL results locally after one refresh, or perform the merge on the SQL Server side by importing the smaller workbook data into a staging table and using a SQL JOIN before loading the final result.

Does WPS Office include Power Query?

WPS Office focuses on compatible spreadsheet editing and does not replace Power Query's server-side merge capabilities. You can use WPS Office to manage staged Excel workbooks, open .xlsx files, and prepare local data for import.