Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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
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.
@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.
Hi @bideveloper555 ,
Did you try appending data from 2 tables into 1 table in Power BI?
Thanks,
Pragati
hi
i will have primary key violation.as you can clearly see ID has same value.
thanks
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |