Consolidating multiple pbix files into one report

[Sportynick]

Hi experts,

Have created five pbix files, each created from different underlying datasets, with associated m-code and dax scripts. For each, the final output is a financial report in a standard format (i.e. five reports).

I now need to combine all five reports into one "consolidated report".

How to do this in the most efficient way?

Ideally it should be linked so that once any of the five reports are adjusted, the single consolidated report is automatically updated.

Thanks in advance for your help.

[Sportynick]

Have read these two posts previously. Aware of but rather not use pin option in Service, want to keep it at Power BI Desktop level, and pinning only solves 1/2 of my issue, as i also need to sum all the numbers in each field to get a consolidated number.

When the other option is done, i.e. copy - paste, for both the visual report and the m-code in "transform" data, i get a significant number of errors appearing on the visual report. Seems that there might be no easy answer and only way is to re-create each field where there is an error. Hoping there is a better way to get a seamless error-proof experience.

[Anonymous]

In desktop you can't pin visuals. why don't you go for two pages option?

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[Sportynick]

Hi Pravin, yes i'm intending to show each of the five financial reports in its own page, and then one page with consolidated numbers. But each of the five are in their own .pbix files now. 

[Anonymous]

Hi @Sportynick 

Load you datasets in report and them create seperate pages for particular requirements.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[Sportynick]

Yes, seems that is what i need to do now, which is rather tedious as it means recreating many things and risk of inconsistencies in the recreated reports compared to original reports. Hope to see a feature in power bi that allows easy consolidation across multiple .pbix files, especially with reports that have the same row headers (there are multiple people working hence split workload and each one created a .pbix file with a report). Otherwise, it's very tedious for consolidator to do up the combined group report.

[Anonymous]

Ask users for dashboard...i means you can pin multiple visual from different reports to dashboard.
If users are not agree then you can create the reports again. you can't do much.

Thanks
Pravin

[Tahreem24]

@Sportynick ,

Please refer the below Thread to get the solution:

https://community.powerbi.com/t5/Desktop/Combining-separate-PBI-reports-into-a-single-PBIX-file-same...

Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.

[Anonymous]

Try these solutions.

https://community.powerbi.com/t5/Power-Query/Merging-PowerBI-Files/td-p/7626

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.