Forum Discussion
PDF Extraction issue in Power BI Paginated Report
Hi all,
I have created a paginated reporet using Power BI Report Builder. when i export the report to PDF from my local environment, the layout renders correctly with all content appearing on a single page as expected.
However, after publishing the report to the Power BI Service, the PDF export results in the content being split across multiple pages or into different tables, which is not the intended behavior.
Has anyone encountered a similar issue or have suggestions on how to resolve this layout inconsistency after publishing?
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.
6 Replies
In Power BI Report Builder, ensure the total report content width including margins is less than or equal to the defined page width. Check this if it works,
- Go to Report Properties.
- Set:
- Page Width: 8.27in (for A4)
- Left/Right Margins: 0.25in each
- Ensure your report body width ≤ 7.77in (8.27 - 0.25 - 0.25).
- Also, turn off CanGrow for textboxes if not needed.
Thanks for your suggestion, I have tried this but still not working as expected.
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.
Hi Patra1234,
We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.
If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.
Thank you.Hi Patra1234,
We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.
If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.
Thank you.Hi Patra1234,
We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.
If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.
Thank you.
