Combine multiple reports

[Lucas_Phil]

Hi everyone!

I have one question that looks like a thorn in our side as Power BI users.

1 - Do we have an easier way to combine multiple reports? Or to take some cards/charts from multiple reports to create a new one? 

I have a lot of reports from different sectors and want to create one that gather the main information from each one. The perfect world would be one or two pages with some selected cards and charts, with a field that the person could click and then open the dashboard related to that sector. In my research looks that we can't combine in a simple way multiple reports :/. 
Can someone confirm this to me? It's weird to think that we don't have any function on Power BI as "merge queries" or something like that. An option I saw it is with ALM ToolKit, helps a lot since it copies the measures, the part we are suppose to do manually.
Or if you have a different idea, please share with me!

Maybe at power BI Service we have something that takes the info from different published dashboards and I didn't see it yet. Don't know, kind of lost here thinking in how much work gonna have gathering everything manually.

Thank you all in advance! 
Have a nice day.

[Anonymous · Accepted solution]

Hi @Lucas_Phil ,

If you need the report to be interactive, you could refer this blog DirectQuery for Power BI datasets to connect multiple datasets in Power BI Desktop then create new report.

If you not need interactive between reports, just simply pin the visuals to dashboard.

Best Regards,

Jay

[Lucas_Phil]

Hi Jay!!

The directQuery for datasets really looks something, the blog helped a lot as well.
We here still need to decide if we want to be interactive or not, thank for both suggetions!