Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
UncleLewis
Responsive Resident
Responsive Resident

Merge Reports

Hi all,

 

Using PBIRS.

 

Is it possible to merge 2 reports so that the 2nd report simply adds additional pages to report 1?

 

Thanks,

w

4 REPLIES 4
UncleLewis
Responsive Resident
Responsive Resident

Thanks Henry,

 

I don't see any preview features under options.

I am using PBIRS, not PBID

My version of Desktop is specifically for Report Server.

 

Thanks,

-w

Hi @UncleLewis ,

 

PBIRS and PBID have nearly similar functions. Is it possible to further describe your application scenario. Is it possible to connect multiple data sources in the same pbix file to create different reports and then implement merging between the reports? I have done a test in PBIRS, using the function of button, to achieve jumping between reports, does it meet your needs?

vhenrykmstf_0-1635315901311.png

vhenrykmstf_1-1635315914467.png

 


Looking forward to your feedback.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks Henry,

 

We inserted a button on R1 to go to R2, but we do not like it

Seems not possible to merge since different Data Model in both reports so we are going to re-create R2 as additional Pages in R1. after we get all the detail of the Data Model correct.

 

Not ideal, but it is what it is.

 

Thanks

-w

v-henryk-mstf
Community Support
Community Support

Hi @UncleLewis ,

 

Do you want to merge reports from different data sources? It seems that you can't merge them directly, and even if the merge is successful, the merged page is just a static page because you can't connect to the data source corresponding to the report.

 

I suggest you to turn on the following option in Options, and then connect the data sources corresponding to the original different reports to generate the corresponding reports.

vhenrykmstf_1-1635127993025.png


If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.