Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

@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!! 😊

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors