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...

[Ike0911]

OK thank you for that information. 

I guess I'll need to reach out to my IT department and see if that feature is enabled 🙂 

Appreciate the response 

Regards,
Dwight

[Ike0911]

Hi Amine,
I am trying to follow the steps you showed in your resolution, but I don't have the 
"DirectQuery for PowerBI Datasetsand AS" option to check. See below: 

NOt sure if it's a difference in Versions or what. 
Here is my Version INformation:

Thanks for any assistance you can give. 

[aj1973]

Hi @Ike0911 

That was a preview feature back in 2021, now it is by default checked but it needs to be enabled at the Tenant level by Power BI Admin.

[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