Need Help adding a table including created measures from one report into another report

Hi Clockwise,

To bring table 2 with all measures, calculated columns, and model logic from Report 2 into Report 1, importing the raw data (like a spreadsheet) won’t transfer the semantic model objects, such as measures, relationships, or hierarchies. To move everything, you need to reuse or connect to Report 2’s semantic model.

The easiest way is to open Report 2, -- Model view, copy the measures and calculated columns, then paste them into Report 1 (right-click the table -- New measure / New column → paste DAX). If you have many measures, using Tabular Editor (External Tool) can speed up the process: open Report 2, copy the table/measures in Tabular Editor, then paste them into Report 1.

Alternatively, you can use a Live connection / DirectQuery for Power BI semantic models. Publish both datasets, then in Report 1 go to Get data --  Power BI semantic model -- select Report 2 dataset. This keeps all measures intact and lets you reuse visuals without recreating logic.

If you want a combined dataset, use Model view -- Manage relationships after connecting to table 2, making sure common keys are related so measures work properly.

In summary, measures can’t be imported through Excel or source import; they need to be copied via DAX, moved with Tabular Editor, or reused by connecting to the semantic model. Using the semantic model connection is often the cleanest and easiest way to combine reports.

Thank you.