Forum Discussion
Paginated Report
Hi Community,
I have Customer Balance PBI Report with 7 pages - each page has different filters
Main page shows customer balance view for all legal entities for Leadeship view, 2nd page has Canada entity with different filters for manager/user level view similarly other pages for other legal Enitites. User subscribe to get email, as we know it shows only snapshot of the report not the entire page and they dont have scroll option as it more than 200+ rows.
User want to have view of entire report, will Paginated report be one of the options? If yes, can this kind of view be achieved in single paginated report or we need to create 7 different .rdl reports?
Thanks in advance!
Yes ,Paginated Report is the right option for this use case.
-
It can display all rows without any scroll or data limit.
-
You don’t need to create 7 different .rdl files.
-
Build one report and use parameters for each view (Leadership, Manager, Canada, etc.).
-
Add page breaks so every view appears on a separate page.
-
When exporting to PDF or Excel, users will get complete data for all sections.
-
Much easier to maintain and update one report instead of managing multiple files.
-
Hi SowmyaTupakula,
Yes, that is possible, just set up the entity as a parameter.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
6 Replies
Yes ,Paginated Report is the right option for this use case.
-
It can display all rows without any scroll or data limit.
-
You don’t need to create 7 different .rdl files.
-
Build one report and use parameters for each view (Leadership, Manager, Canada, etc.).
-
Add page breaks so every view appears on a separate page.
-
When exporting to PDF or Excel, users will get complete data for all sections.
-
Much easier to maintain and update one report instead of managing multiple files.
Thanks rohit1991
I have a follow query -
Current report I subscribe users based on Entity and they see what they want, with Paginated reports is that possible without giving additional details?
For say CA users/managers only want file with CA Customer data and do not want to see US, UK ..Etc. Is that achievable?Hi SowmyaTupakula,
Yes, that is possible, just set up the entity as a parameter.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
-
Hi SowmyaTupakula,
Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to tayloramy & rohit1991 for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
Hello SowmyaTupakula,
We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.
Thank you.
Yes, moving to a Paginated Report would be an effective solution for your scenario, especially since users want to receive the entire data view in email, rather than a cropped snapshot of a Power BI report page. Unlike standard Power BI reports, which are optimized for interactive exploration and visual summaries, Paginated Reports (.rdl files) are designed for pixel-perfect, printable, and scrollable tabular layouts that can handle large datasets with hundreds or thousands of rows. They are ideal for financial or operational reporting use cases where users need a complete data extract — either as a PDF, Excel, or email attachment — without being limited by screen space or scrolling restrictions.
You can definitely achieve your multi-entity requirement within a single Paginated Report by designing parameterized filters (for example, a parameter for “Legal Entity”). Using this approach, one .rdl file can dynamically render different entity-specific views, such as Canada, U.S., or others, based on the parameter value. This eliminates the need to create seven separate paginated reports. You can then schedule email subscriptions in Power BI Service, setting up one per entity if needed, so that each recipient automatically receives their filtered version of the report. In summary, a single, parameter-driven Paginated Report would be both efficient and scalable for providing full report views to users across multiple entities.
