Forum Discussion
Need Help adding a table including created measures from one report into another report
So I have two different reports, report 1 and report 2, they are related but their data sets are different, though they have some common keys. I want to have one report with both data sets and visuals, basically combine the reports. I was able to limit each report use only one table data set as the source, let's call them table 1 and table 2. So I imported the source of table 2 from report 2 (which was a spreadsheet) into report 1 . However as you can imagine in this process, I lost all the measures that I crated in table 2. And I do not have the measures and columns I have created inside report 2 anymore in the combined report. How can I literally import everything including measures and columns of table 2 into report 1 ?
I imagine after that I can copy paste visuals freely from report 2 into report 1.
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.
7 Replies
Hi Clockwise ,
The easiest way is probably going to be by using the TMDL view in Power BI. Use Tabular Model Definition Language (TMDL) view in Power BI Desktop - Power BI | Microsoft Learn
What I would do if I were you is grab the TMDL code from both reports and run them through Copilot prompting it to combine the two reports.
I haven't done this exactly before so it may take a bit of talking to copilot to get a working version, but this should be a good first step!ok, I do not have access to Copilot on PBI for some reason. Any other way to figure this out?
You should be able to use a normal copilot or AI to help. The copilot in power bi is an extra licensing feature but for this stuff, you can just copy paste into the normal copilot. Microsoft Copilot: Your AI companion
Hi Clockwise,
We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help.
Thank you.No fully, I have not been able not get the details of it.
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.
Hi Clockwise,
Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If you still have any questions or need more support, please feel free to let us know.We are more than happy to continue to help you.
