Copy Power Bi Report page PBIX into another power bi PBIX

[bideveloper555]

hi

I am using Devops Data source but we have 2 different projects.

Azure devops in both projects have same data sets(tables,column but data is different).

lets say i have basic table in one power bi report

ID Name

1   Jack

In anoher power bi report

ID Name

1   Rose

i want to show 2 table "Visualizations"in one report with from 2 different projects.

ID Name

1   Jack

ID Name

1   Rose

i could pull data sets in one report but this will break relationships between dataset.

i have same users,workitems in both projects.

can i use embed URL of other power bi report  into another power bi.This will solve the problem. but i dont know how?

[v-lili6-msft]

hi  @bideveloper555 

You could use PBIT file in the power bi desktop, see more details by this blog:

https://www.powerbitutorial.org/tutorials/power-bi-templates/

https://www.powerbitutorial.org/tutorials/power-bi-templates/

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

Regards,

Lin

[bideveloper555]

hi,

i have loaded 2 data sets into power bi and made a relationship for those 2 sets.

decided to create different page for each data set as sync wont work for both data sets.

[amitchandak]

@bideveloper555 , as of now, the merge of to power bi data set is not available. You have to merge the tables in power BI.

You can only copy-paste visual between two power bi files having the same data model

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[bideveloper555]

thank you.

can you can copy visualization between each other but here we have different data but model is same.

i want to display data from 2 projects in one report but model are same but not data.

[Pragati11]

Hi @bideveloper555 ,

Did you try appending data from 2 tables into 1 table in Power BI?

Thanks,

Pragati

[bideveloper555]

hi

i will have primary key violation.as you can clearly see ID has same value.

thanks