Multiple Users - Multiple Reports - One Dataset - Merge all the reports to create the final report

[NKotak_Leecare]

Hi All,

Background:

• Multiple Users with same permission level
• Multiple Reports (every users work on individual report - the work is to create one page per report per user for final one master report)
• One Dataset - (eg. db_dummy) which is published in the service and all the reports are live connected with this dataset
• One user changes in published dataset (db_dummy) by downloading the PBIX report and again uploading it with the same name. The changes made are reflected in the connected reports. 

Issue:

• Parallel multiple users works on individual reports which are live connected to the single dataset. Now this individual reports contains pages which needs to be merged into one report. Once all the reports are prepared using single dataset, how do we merge those reports into one?

Appreciate your time and help in advance! 😀

[lbendlin · Accepted solution]

Collect all the report pbix files. Open all pbix. Copy/paste pages between the pbix files.  This will work because all reports point to the same data model.

[NKotak_Leecare]

Thank you so much for your reply!

Just one question on that, is it like pining from multiple reports to one? And can we pin (multiple) enitre dashboard to the other?

Once again, appreciate your help and support.

Cheers!

[NKotak_Leecare]

For multiple datasets - Tips And Tricks To Merge Two Power BI Reports (c-sharpcorner.com)

[lbendlin]

This has nothing to do with pinning.  Please read about the differences between reports and dashboards.

[NKotak_Leecare]

Okay, got it. Thanks!