Combine 3 datasets from 3 different pbix datasets (not within the same PBIX)

[Anonymous]

I have 3 reports (pbix) that collect and transform data within each area:

- Economy (Source: MS SQL DB)

- Demand (Source: >10 Excel spreadsheets) 

- Projects (Source: MS SQL DB and spreadsheets)

All 3 report are published to Power BI Services.

I need to create a new master report (Master1) that includes and create relationships between all 3 pbix datasets in order to avoid having to create connections, load and transform data again.

I have searched the internet and have not been able to find anything and hope someone here has a solution or hack.

[Joorge_C]

Hi, It looks like the best option is to have a cross drilling accross all linked reports

https://docs.microsoft.com/en-us/power-bi/desktop-cross-report-drill-through

I checked dataflows or streaming dataset, but it looks like these will not be able to acomplish what you are looking for.

[Anonymous]

Unfortunately I need to show data from all 3 dataset in the same viz so Cross-drillthrough will not solve my problem.