Forum Discussion
PDF Extraction issue in Power BI Paginated Report
Thankyou, BhavinVyas3003, for your response.
Hi Patra1234,We appreciate your inquiry through the Microsoft Fabric Community Forum.
Based on my understanding, the behavior you are observing arises due to differences in rendering between the local preview (soft page-break) and the Power BI Service (hard page-break), as well as variations in rendering engines and page constraints. In Power BI Report Builder, reports are rendered using a soft page-break renderer, which allows content to flow continuously, often resulting in a single-page layout during local previews. However, when exporting to PDF from the Power BI Service, a hard page-break renderer is employed. This renderer strictly adheres to defined page sizes and margins, which may cause content to split across multiple pages if not appropriately configured.
Kindly follow the steps below, which may help to resolve the issue:
- Group related items inside Rectangle containers to maintain layout integrity.
- Review and adjust or remove any unnecessary page breaks.
- Set a larger page height (for example, 11.69 inches) to contain all content on one page.
- Fix the widths of tables and matrices, and use Text Wrapping for long values.
- Use Print Layout in Report Builder for an accurate preview before publishing. Export a simplified version to isolate layout behaviour.
Additionally, please refer to the following links for further information:
Page layout and rendering in Power BI paginated reports - Power BI | Microsoft Learn
Export Power BI paginated report to a PDF File (Power BI Report Builder) - Power BI | Microsoft Learn
Export Power BI paginated reports - Power BI | Microsoft Learn
Pagination in Power BI paginated reports - Power BI | Microsoft LearnIf you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.
Should you have any further questions, please feel free to contact the Microsoft Fabric community.Thank you.
Thankyou, BhavinVyas3003, for your response.
Hi Patra1234,
We appreciate your inquiry through the Microsoft Fabric Community Forum.
Based on my understanding, the behavior you are observing arises due to differences in rendering between the local preview (soft page-break) and the Power BI Service (hard page-break), as well as variations in rendering engines and page constraints. In Power BI Report Builder, reports are rendered using a soft page-break renderer, which allows content to flow continuously, often resulting in a single-page layout during local previews. However, when exporting to PDF from the Power BI Service, a hard page-break renderer is employed. This renderer strictly adheres to defined page sizes and margins, which may cause content to split across multiple pages if not appropriately configured.
Kindly follow the steps below, which may help to resolve the issue:
- Group related items inside Rectangle containers to maintain layout integrity.
- Review and adjust or remove any unnecessary page breaks.
- Set a larger page height (for example, 11.69 inches) to contain all content on one page.
- Fix the widths of tables and matrices, and use Text Wrapping for long values.
- Use Print Layout in Report Builder for an accurate preview before publishing. Export a simplified version to isolate layout behaviour.
Additionally, please refer to the following links for further information:
Page layout and rendering in Power BI paginated reports - Power BI | Microsoft Learn
Export Power BI paginated report to a PDF File (Power BI Report Builder) - Power BI | Microsoft Learn
Export Power BI paginated reports - Power BI | Microsoft Learn
Pagination in Power BI paginated reports - Power BI | Microsoft Learn
If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.
Should you have any further questions, please feel free to contact the Microsoft Fabric community.
Thank you.