Forum Discussion
How to combine multiple existing Power BI datasets
We are likely targeting a solution that looks like below. Its not a strong solution as the lineage is a little messy but with the reports now in a common location, we can move forward with delivering the solution to the intended audience
-in workspace1 create a visual-a
-in workspace2 create a visual-b
-in workspace3 create a visual-c
-'save a copy' of visual-a to workspace4
-'save a copy' of visual-b to workspace4
-'save a copy' of visual-c to workspace4
---------------------------------------------
-deliver the 3 reports in the workspace4 app as tabs on left menu
OR
-deliver the 3 reports in a dashboard within workspace4
Hi MattClapp ,
One way to work around, creating dashboard could combine different visuals from different reports.
Please refer to:
https://www.linkedin.com/pulse/enhance-your-power-bi-skills-combine-multiple-jeroen-van-de-erve
https://www.youtube.com/watch?v=Vhn2SLt_kts&t=5s
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I beleive you can only combine reports within a single dashboard when they are in a common workspace. In this scenario, we have 3 different workspace+datasets .
I beleive this is the only option:
https://ideas.powerbi.com/ideas/idea/?ideaid=851b8e21-2d86-4406-a2b5-9e12bd379329