Power Query Problems

Reuse Excel Power Query Data and Data Models in Another Workbook

Jason MillerJason Miller Nov 14, 2026 868 views

Question details

Use data, queries, or Data Model components from one Excel workbook in another.

Reuse Excel Power Query Data and Data Models in Another Workbook
Product
Microsoft Excel Power Query and Data Model
Device & OS
not provided
Scenario
A user wants a separate workbook to reuse data transformations, measures, columns, and filters from an existing workbook.
Observed behavior
The user needs to know which steps belong in each workbook and receives an error when connecting to ThisWorkbookDataModel.
Before you start

Open both the source and destination workbooks and identify whether you need the source tables, the query definitions, or the Data Model measures and relationships. Check that you can access the original data sources and have any required credentials.

Solution 1Recommended

Import source workbook data into the destination workbook

Use this method when the data you need is available in source workbook tables or worksheets.

The Excel workbook connector imports available workbook data; it does not automatically copy Power Query definitions or the source Data Model's measures and relationships.

1
Start in the destination workbook

Open the workbook where you want to use the data. Select Data > Get Data > From File > From Excel Workbook.

2
Select the source workbook

Choose the workbook containing the data, then select a table or worksheet in the Navigator.

3
Transform and load the data

Select Transform Data to adjust the query. When finished, use Close & Load To and select Add this data to the Data Model if you need it in the destination model.

4
Recreate model components

In the destination workbook, use Data > Relationships or Power Pivot > Manage, where available, to recreate the required relationships, calculated columns, and measures. Recreate report filters as needed.

Data Model limitation: Importing a worksheet or table is not the same as connecting to the source workbook's internal Data Model. Measures and other model definitions must be recreated or supplied through a suitable shared data source.
Free Microsoft Office alternative

Work with Excel Workbooks in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility, making it easy to move everyday workbook editing to WPS. It does not fix Excel's internal Data Model connection errors.

Open and edit Excel XLSX workbooksWork with spreadsheet data in a familiar interfaceMove everyday workbook editing from Microsoft Office to a lightweight suiteUse free spreadsheet, document, and presentation tools
microsoft office alternative - wps office

Frequently Asked Questions

Which workbook should I use to import the data?

Open the destination workbook and select Data > Get Data > From File > From Excel Workbook. Then choose the source workbook in the file picker.

Will importing a workbook copy its Power Query definitions?

No. The workbook connector imports available data, such as tables or worksheets. To reuse a query's transformations, copy its code from Advanced Editor into a blank query in the destination workbook and resolve any dependencies.

Why does connecting to ThisWorkbookDataModel cause an error?

ThisWorkbookDataModel refers to a workbook's internal Data Model and should not be assumed to be an external connection to another workbook's model. Import accessible source data or copy the queries, then recreate the needed model components in the destination workbook.

Can a connection file transfer my measures and relationships?

A connection file can provide connection information, but it does not automatically transfer the source workbook's Data Model measures or relationships. Recreate them in the destination model using Power Pivot and Data > Relationships, where available.