Forum Discussion
PDF Export Missing HTML Table Content
Hi Dynizju,
Unfortunately, I don't believe there is a native way for Power BI report exports to automatically split a scrollable visual across multiple PDF pages. The same has been answered in another post - PDF export do not show full table
What you're seeing is expected behaviour. When exporting a standard Power BI report to PDF, only the visible portion of a scrollable visual is captured. Any rows that require scrolling are not included in the PDF export.
Given your scenario, simply increasing the page height isn't ideal because the number of rows varies based on the selected filters. You would either end up with truncated data or large amounts of unused whitespace.
For requirements where the full table must be exported regardless of the number of rows, the recommended approach is typically a Paginated Report. Paginated Reports are designed for exactly this use case and will automatically flow table data across multiple pages when exported to PDF, ensuring all rows are included without requiring scrollbars.
If moving to Paginated Reports isn't an option, the alternatives are generally limited to:
- Exporting the underlying data to Excel/CSV instead of PDF.
- Redesigning the report to reduce or eliminate scrolling.
- Using a dedicated printable report page specifically for export purposes.
So in short, if the requirement is"export all rows to PDF and automatically span multiple pages", I would strongly recommend a Paginated Report. Standard Power BI report exports don't currently support automatic pagination of scrollable visuals during PDF export.
If my answer helped you solve the problem, please consider accepting it as the solution and help other members to use the same solution in same/similar situations.
Solution SageUnfortunately, this isn't supported by the standard Power BI PDF export.
When exporting a report to PDF, Power BI exports the report exactly as it is rendered on the report canvas. For table and matrix visuals, only the visible portion of the visual is captured—content that requires scrolling is not automatically paginated or included in additional PDF pages.
Current limitations
❌ No automatic pagination of table or matrix visuals during PDF export.
❌ No option to split a long table across multiple PDF pages.
❌ Report page size cannot dynamically adjust based on the amount of data.
Possible workarounds
1. Use Paginated Reports (Recommended)
If your requirement is to export tables that may span multiple pages, Power BI Paginated Reports are the best solution. They are designed for:
Automatic page breaks
Multi-page tables
Dynamic row counts
Print-ready PDF, Excel, and Word exports
This is the recommended approach for operational or printable reports.
2. Export the underlying data
If users primarily need the complete dataset rather than a formatted PDF, they can use:
Export data (CSV or Excel)
Analyze in Excel (if enabled)
This ensures all rows are available without being limited by the visual's scroll area.
3. Redesign the report
If staying with interactive Power BI reports, consider:
Using drillthrough pages.
Applying additional filters or slicers to reduce the number of visible rows.
Splitting the report into multiple pages based on business categories.
This won't create automatic PDF pagination but can make exports more manageable.
Recommendation
For reports where the number of rows varies significantly and complete PDF output is a requirement, Power BI Paginated Reports are the intended solution. They provide automatic pagination and are purpose-built for scenarios that standard Power BI reports don't support.
For more information:
Paginated Reports in Power BI: https://learn.microsoft.com/power-bi/paginated-reports/paginated-reports-report-builder-power-bi
Export Power BI reports to PDF: https://learn.microsoft.com/power-bi/collaborate-share/end-user-pdf