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

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

Reply
Anonymous
Not applicable

Is Paginated reports the right tool for this task?

Hello,

first of all I'm sorry if this is not the place where I should ask this question, but I was not able to find any dedicated forum for Paginated reports issues.

 

I wanted to ask if Paginated reports is the tool suited for what I need to achieve. Here is a short description:
I want to build a "deck" of reports. One PDF (or potentially PPTX) file which contains multiple different reports, some of which are "looped" while one of input parameters is being changed. I know this is achievable in Power BI Paginated reports using many workarounds, etc. but it seems very unintuitive, complicated, undocumented and I was not able to find a single person/tutorial online dealing with similar topic so I have no idea what are some "best practices" for similar tasks. All tutorials deal with creating a single report. Maybe nesting one report inside of another, using subreports. But nobody is building PDFs with 20+ pages consisting of 6-7 different reports. 

I'm grateful in advance for any helpful comments.

2 REPLIES 2
johnyip
Solution Sage
Solution Sage

In my opinion, using PowerBI Report Builder for the prepration of Paginated Report for PowerBI seems suitable for your task, given your words.

 

You should use parameters as you have suggested in your paginated report.

 

johnyip_0-1689058631361.pngYou can insert your paginated report into your PowerBI report after uploading it on a workspace.

 

 

Alternatively, if your deck of reports doesn't include visualizations like table/matrix which require user to scroll (or pgianted in order to show all of the contents), you may actually just build the report solely using PowerBI right away, and then export it online via PowerBI service as PDF.



Please mark my post as the solution if this answers your question!
Appreciate your Kudos !!
Anonymous
Not applicable

I'm not sure if you understand what I mean. My question has NOTHING to do with Power BI Desktop. As far as I know, in power BI Desktop you can't create paginated reports. (I know there is a visual where you can import Paginated report into PBI Desktop report, but I think that is really not useful for me)

What I need is one single PDF file, with 20+ pages, with page numbers, headers and footers, some reports looped while passing some different parameter as an input, etc. Imagine deck of reports, PDF which you receive and on every page you have one table/chart. And all this needs to be created with ONE click.

Helpful resources

Announcements
Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.