export a paginated report to PDF by page range

[eowens27]

I have a paginated report with 1 record per page. These are letters that will be sent to a mail house to print. The issue I am having is that the pdf that is generated is too large to edit after it has been exported from Power Bi report builder. These reports often have up to 100,000 pages and the pdf comes out to be over 300mb and it just hangs if I try to split it up in Adobe Acrobat. I need a page range of no more than 20,000 pages in each file. Is there a way to export the report by a page range? Crystal Reports allows this type export but I can't seem to make it happen in Power Bi. If I try to print to a pdf it will let me select a page range, but I just get an error if the page range is more than about 5000.

[Anonymous]

Hi @eowens27 

Has your problem been resolved? If so, could you mark the corresponding reply as the solution so that others with similar issues can benefit from it?

Best Regards,

Jayleny

[parry2k]

@eowens27 

@eowens27 I have many video on paginated reports on my YT channel - here is one such video https://youtu.be/nkR0VU8-euw

[parry2k · Accepted solution]

@eowens27 can you add a parameter to filter report by x number of pages, and use that method to limit the output.

[eowens27]

Can you give me an example of how the parameter and filter would be set up? I keep getting an error that the page number can only be used in the footer.