cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

How to create a paginated report of "multi-paged" subreports with Power BI?

I want to create a master report that consists of multiple 5-page reports for each sales region (say 10 regions). I am creating a parameter to filter the results based on the region. Every example I found for Power BI paginated report was based on 1-page reports. I wanted to check if it is possible to create my master reports of multi-paged subreports with Power BI paginated report.
 

One more piece of information to add here is that each of my subreports includes a combination of tables and graphs and the number of rows in some tables may vary for each regional report (pushing some rows to the next page). It is also required to conditionally change the font color for certain rows in the table. Please let me know if these features can be applied too.

 

Thanks

1 ACCEPTED SOLUTION

First of all I would like to mention my solution works with Power BI Report Server, not service, as this subject is under Report Server.

 

From back to forward:

4) As far as I know; no

3) This is capability of Power BI Report Server

2) Yes, it's all about grouping

1) For pdf reports, it's different than Excel. Excel is single file containing multiple sheets. But For pdf there is no such functionality. You can generate multiple pdf files for each group but with data driven subscriptions.

View solution in original post

3 REPLIES 3
Resolver II
Resolver II

Hi Saglamtimur,

 

Thank you for the reply. The link that you kindly shared shows that there's the capability to create a multi page report. Can you also confirm that:

 

1) To create pdf reports, we should follow the same instruction you gave fro Excel sheets?

2) With paginated report, we can put my individual multi-paged reports together and create a master report? For instance, if the individual report for each company contains 5 pages and we have 10 companies to report on, we want to create a master report of 50 pages, which includes all those 5 reports.

3) Are we required to purchase Embedded/Premium Capacity to be able to achieve this?

4) One last question; can we create a table of contents for the master report?

 

Looking forward to your insights.

 

Thanks for your help!

 

First of all I would like to mention my solution works with Power BI Report Server, not service, as this subject is under Report Server.

 

From back to forward:

4) As far as I know; no

3) This is capability of Power BI Report Server

2) Yes, it's all about grouping

1) For pdf reports, it's different than Excel. Excel is single file containing multiple sheets. But For pdf there is no such functionality. You can generate multiple pdf files for each group but with data driven subscriptions.

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors