Forum Discussion
Power BI Report PDF Extraction through subscription - Incomplete Data Issue
Was able to resolve this by increasing the Page Length , so Paginated report was not needed.
But thank you all for your inputs!
Hi Anusha66 ,
With a standard Power BI report page, a PDF subscription cannot automatically “overflow” a scrollable matrix to a second page. The export captures what is visible, and there’s no setting to force a multi-page flow for a single visual in a normal report. The recommended approach is to use a paginated report for multi-page PDF output.
What you can do
Use a Paginated Report (best for multi-page PDFs)
Paginated reports are designed for printing/exporting to multi-page PDFs, with proper page breaks.
They can pull data from the same Power BI dataset and render long tables/matrices across many pages.
Steps:
Install/launch Power BI Report Builder (the designer for Paginated Reports) and/or use Power BI Desktop with the Paginated Report extension.
Connect the paginated report to the same Power BI dataset you use in the standard report.
Design a table or matrix (tablix) and set up grouping as needed. Add page breaks between groups so data flows onto multiple pages (e.g., page break after a Region or Customer group).
Add headers/footers, page numbers, and any required filters.
Publish the paginated report to a workspace in Power BI Service.
Create a subscription for the paginated report and choose PDF as the export format. The recipient will receive a multi-page PDF with proper page breaks.
Notes:
Paginated reports are the supported path for “overflow” printing. They are specifically built for this scenario.
Ensure your dataset has the necessary permissions and that you stay within data-export/row limits for PDFs (Paginated Reports handle paging, but check data size if you have extremely large datasets).
Please mark this post as solution if it helps you. Appreciate Kudos.