Export to PDF - wrong page size

[Brendan42]

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? 

[Protype83]

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

[LeandroRossi]

Update WebView2 to 118.0.2088.76, it's work for me

[bingzhougz]

When converting to PDF in the new version of Power BI, there is an issue of incomplete pages?

[pucci]

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.

[najiro8v]

Thanks, this work for me

[NamitHarish]

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.

[NamitHarish]

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.

[Anonymous]

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.           

[Brendan42 · Accepted solution]

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.

[Brendan42]

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.