Forum Discussion
Export to PDF - wrong page size
Morning all, I have a report for which I've set the Canvas settings on each of the pages to enable exporting to A4 portrait (image below). However when I view the report in a browser and "Export - PDF" I get a file with two different page sizes. The first page is A4 sized, but the second is A3. I've double-checked and the canvas sizes on all the pages are identical. I must be missing something, any help appreciated?
Thanks for the info Stephen. Those first two pages were originally created as 16:9, with widgets added to that page, then resized to 1123x794 and widgets moved/resized to fit. I wonder if that was the cause of the problem?
I've now resolved my issue by just recreating a blank page for each one, setting to 1123x794 and copy/pasting directly from the affected pages. Deleted old pages and now they all print in A4.
12 Replies
Hello Community Members,
I tried customizing the Canvas Settings and also created a New Page and copy pasted the visuals from original sheet but still the Export prints the pdf only half the visual.
One possible solution is to re-try generating the PDFs. Select View -> Page view -> Fit to Page in the dashboard before publishing. This worked for me.
I tried changing the Canvas Settings as suggested above and then also made the changes by adding a New Page and copying the visuals to a new page but when exporting to PDF, it came in wrong size.
Changing the Page View to Fit to Page/Fit to Width/Actual Size did not help as well.
One alternate fix i found was by uploading the report to My Workspace and from there you can export the report in either PDF File/PowerPoint File.
Thanks, this work for me
The pages zoom level impacts how it exports onto the page.
Export at 100% zoom, and export again at 50% zoom and see how it fills the pages differently.
Check your zoom level before exporting!You are a lifesaver! Thanks for this.
An update. Using Power BI Desktop...
Before After Page 1: A4 as expected Page 1: Now A3! Page 2: A3 Page 2: Still A3 Page 3: Added blank page, same canvas sizes, copy/pasted from Page 2 to Page 3, exports as A4, no problem there now. Hi Brendan42 ,
Reports with unusual custom page sizes may experience issues in export scenarios. For best results, consider switching to a standard page size for your report.
Referece:
Export reports to PDF - Power BI | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the info Stephen. Those first two pages were originally created as 16:9, with widgets added to that page, then resized to 1123x794 and widgets moved/resized to fit. I wonder if that was the cause of the problem?
I've now resolved my issue by just recreating a blank page for each one, setting to 1123x794 and copy/pasting directly from the affected pages. Deleted old pages and now they all print in A4.
When converting to PDF in the new version of Power BI, there is an issue of incomplete pages?
Update WebView2 to 118.0.2088.76, it's work for me
Hello Community Members.
This threats seems to be over 2yo, but for me this is relevant.
I have over 20 tabs what I want export to pdf and print it to end users.
Problem is same, but I have tried different scenarios.
Most of tabs are custom size
Size 1
H: 900 px
W: 1280 px
Few special case have different size,but haven't tried to exported yet.
Size 2
H: 900 px
W: 1440 px
Size 3
H: 900 px
W: 1800 px
Scenario1:
Tabs 1-10
Size equal
1st page is smaller than others.
Scenario2
Tab 1
Full size (A4)
Scenario3
Tabs 1-2
Tab1 Full size(A4)
Tab2 Small size (A3?)
Scenario4
Tabs 1-3
All tabs Full size(A4)
Scenario5
Tabs 1-14
All tabs Full size(A4) except Tab 13 (A3)
After this scenario I check what is different and only thing was different was show size in PBI.
Other was 100%
Tab 13 was 80%
Scenario5 - Possible solution
Tabs 1-14
After changing show size to fit to page
All tabs show on report Full size(A4)!!
Someone advice to try Power BI Report builder, but it is nonsense software and I haven't found any good tutorial videos for it to great report automate.
Best regards
Protype83
