Forum Discussion
PDF export do not show full table
- 1 year ago
Hi Johag,
Thank you for reaching out to the Microsoft Fabric Community Forum. Thank you Cookistador, for your inputs on this thread. I have identified few workarounds that may help resolve the issue. Please follow these steps:
The issue you're encountering is due to scrollable tables in your report. When exporting to PDF, Power BI only captures the visible portion of a table, which includes the rows above the scroll bar. Consequently, the rows below the scroll bar (those not visible without scrolling) are excluded from the export.
Unfortunately, this is a limitation of the standard Power BI export functionality scrollable visuals, such as tables, do not support multi-page exports when exporting to PDF.For scenarios requiring the export of large tables or datasets across multiple pages in PDF format, Paginated Reports are the recommended solution. These reports automatically paginate tables across multiple pages, ensuring all rows are included in the export, even if they exceed the visible portion of the report.
For more details on creating and working with paginated reports, please refer to the following link: View paginated reports in Power BIIf you prefer to continue exporting to PDF and need further clarification on the limitations, you can consult the documentation on PDF export behaviour, which explains that only the visible portion of scrollable visuals (like tables) is exported. This documentation confirms why only the top rows appear in the exported PDF. Export reports to PDF – Power BI
Once you have created a paginated report, you can save and upload it to the Power BI Service, enabling users to view and export it as a PDF seamlessly. Save paginated reports to the Power BI service
If your goal is to export large tables to PDF while maintaining the integrity of the data (i.e., ensuring all rows are visible in the export), the paginated report is the best solution.
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you for using Microsoft Community Forum.
Hi Johag,
Thank you for reaching out to the Microsoft Fabric Community Forum. Thank you Cookistador, for your inputs on this thread. I have identified few workarounds that may help resolve the issue. Please follow these steps:
The issue you're encountering is due to scrollable tables in your report. When exporting to PDF, Power BI only captures the visible portion of a table, which includes the rows above the scroll bar. Consequently, the rows below the scroll bar (those not visible without scrolling) are excluded from the export.
Unfortunately, this is a limitation of the standard Power BI export functionality scrollable visuals, such as tables, do not support multi-page exports when exporting to PDF.
For scenarios requiring the export of large tables or datasets across multiple pages in PDF format, Paginated Reports are the recommended solution. These reports automatically paginate tables across multiple pages, ensuring all rows are included in the export, even if they exceed the visible portion of the report.
For more details on creating and working with paginated reports, please refer to the following link: View paginated reports in Power BI
If you prefer to continue exporting to PDF and need further clarification on the limitations, you can consult the documentation on PDF export behaviour, which explains that only the visible portion of scrollable visuals (like tables) is exported. This documentation confirms why only the top rows appear in the exported PDF. Export reports to PDF – Power BI
Once you have created a paginated report, you can save and upload it to the Power BI Service, enabling users to view and export it as a PDF seamlessly. Save paginated reports to the Power BI service
If your goal is to export large tables to PDF while maintaining the integrity of the data (i.e., ensuring all rows are visible in the export), the paginated report is the best solution.
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you for using Microsoft Community Forum.
- Johag1 year agoAdvocate II
Thanks for the detailed answered.
For my use case it looks like paginated is the way to go. I'll dig in to this and see what kind of magic we can create 😎