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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
tkmiro
Regular Visitor

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
Super User
Super User

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 !!

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.