'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Power BI PDF Export Cutting Off Report Content
Question details
The user needs to fix an issue where exporting a Power BI report to PDF results in the visual content being cut off or improperly zoomed.
- Product
- Power BI Desktop
- Device & OS
- not provided
- Scenario
- Exporting a completed report from Power BI Desktop to a PDF file for sharing or printing.
- Observed behavior
- Report visuals are cut off or zoomed in on the exported PDF, even though the Page View in the application is set to 'Fit to Page'.
Ensure you are running the latest version of Power BI Desktop, as rendering bugs are frequently patched in monthly updates, and verify that your report's Canvas Settings match standard PDF aspect ratios.
Adjust Canvas Settings for PDF Compatibility
Use this solution to ensure your report dimensions natively match standard print sizes, bypassing visual scaling issues during export.
The 'Fit to Page' setting only adjusts how the report looks on your monitor. When exporting to PDF, Power BI relies on the actual Canvas Background size. If the canvas is wider than a standard PDF page, the right side may be cut off during the export process.
Click anywhere on the blank space of your report canvas to ensure no specific visual is selected.
Navigate to the 'Format your report page' pane (the paint roller or brush icon) on the right side of the screen and expand the 'Canvas settings' section.
Click the 'Type' dropdown and change it from 'Custom' or '16:9' to standard dimensions that match your target document, or manually adjust the Custom pixel width to fit standard ratios.
Go to File > Export > Export to PDF and review the newly generated file to ensure no visuals are cut off.
Consult the Power BI Community for Version-Specific Bugs
If the issue started immediately after an application update, it may be a known software bug requiring a specific Microsoft workaround.
View and Manage Your Exported PDFs with WPS Office
While Power BI handles your data visualization, WPS Office provides a lightweight, comprehensive suite for managing your exported PDF reports. Easily view, merge, and present your data without the heavy resource demands of other software.
- 1. Download and Install: Download WPS Office for free from the official website and complete the quick installation.
- 2. Open Your PDF Report: Launch WPS Office, click on 'Open', and select the PDF report you exported from Power BI.
- 3. Review and Annotate: Use the built-in PDF tools to highlight key data points, add comments, or merge the report with other business documents.
Frequently Asked Questions
Why does 'Fit to Page' not apply to my Power BI PDF export?
The 'Fit to Page' setting only dictates how the report renders on your local display monitor. The PDF export function ignores monitor scaling and instead pulls the hard-coded dimensions set in the report's Canvas Settings.
Can I export hidden pages in Power BI to PDF?
No, by default, Power BI excludes hidden pages and tooltips from PDF exports. If you need a hidden page to appear in your final PDF document, you must unhide it before exporting.
Is there a size limit for exporting Power BI reports to PDF?
While there isn't a strict file size limit, Power BI Desktop may struggle or time out if the report contains an excessive number of pages, extremely high-resolution custom visuals, or complex background images. Keeping reports under 30 pages can help ensure a smooth export process.
How do I fix visuals zooming in during a PDF export?
Zooming issues often happen when custom scaling is applied in Windows display settings. Ensure your Windows display scale is set to 100%, and verify that your Canvas Settings in Power BI use standard pixel ratios.
