How to merge two/multiple power bi reports/dashboards

[sujitjena]

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?

[aj1973 · Accepted solution]

You need to check box

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

[aj1973]

Hi @sujitjena 

You can use 

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.  

[sujitjena]

@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]

@sujitjena 

Yes that is possible,

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

[sujitjena]

@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 · Accepted solution]

You need to check box

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

[sujitjena · Accepted solution]

@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]

Welcome