Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
bideveloper555
Helper IV
Helper IV

Copy Power Bi Report page PBIX into another power bi PBIX

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?

6 REPLIES 6
v-lili6-msft
Community Support
Community Support

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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
Super User
Super User

@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

 

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
Super User
Super User

Hi @bideveloper555 ,

 

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

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

hi

 

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

 

thanks

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.