Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Solved! Go to 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
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
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!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
87 | |
84 | |
65 | |
49 |
User | Count |
---|---|
140 | |
114 | |
110 | |
59 | |
59 |