cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sujitjena
Resolver I
Resolver I

How to merge two/multiple power bi reports/dashboards

Hi,

 

I am trying to combine multiple power Bi reports or dashboards into one report or dashboard. Or is it possible to combine/pin visuals from diffeent work spaces? Is any of it possble?

 

2 ACCEPTED SOLUTIONS
aj1973
Community Champion
Community Champion

You need to check box

aj1973_0-1629805431605.png

 

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-s...

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

@aj1973 : Awesome!! it works. Ofcourse there are few limitations that can see. But i think i can use the measures and tables to build new dahsboard combining them. Thanks a lot!! 😊

View solution in original post

7 REPLIES 7
aj1973
Community Champion
Community Champion

Hi @sujitjena 

You can use 

aj1973_0-1629739086026.png

to drillthrough across reports but you can't combine reports from different workspaces. Though you can pin visuals from different reports to a single dahsboard.  

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

@aj1973 : Thanks its a good way to drill through. What i am looking for is a way to import data sets from multiple Pbix files into a single report and consolidate into one report. Is this possible?

aj1973
Community Champion
Community Champion

@sujitjena 

Yes that is possible,

aj1973_0-1629804362625.png

 

From the desktop import your datasets and build your new report.

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

@aj1973 : I explored this option, unfortunately that doesnt work either. Once you have selected one data set, it doesn't allow you to select another PBi data set in the same report.

aj1973
Community Champion
Community Champion

You need to check box

aj1973_0-1629805431605.png

 

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-s...

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

@aj1973 : Awesome!! it works. Ofcourse there are few limitations that can see. But i think i can use the measures and tables to build new dahsboard combining them. Thanks a lot!! 😊

View solution in original post

aj1973
Community Champion
Community Champion

Welcome

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.