Reuse Excel Power Query Data and Data Models in Another Workbook
Question details
Use data, queries, or Data Model components from one Excel workbook in another.

- 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.
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.
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.
Open the workbook where you want to use the data. Select Data > Get Data > From File > From Excel Workbook.
Choose the workbook containing the data, then select a table or worksheet in the Navigator.
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.
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.
Copy Power Query definitions into the destination workbook
Use this method when you need to reuse the original query transformations rather than just import their output.
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.

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.




