Multiple issues with Paginated Report

[dellison]

I created a paginated report in Power BI Service as per my customers requirements. It has a certain number of dummy columns as per my customer's requirements. I tried to delete one of them, and get a vague error: "An error occurred while trying to load the data" 

Not helpful in the least. So i tried downloading it and editing it in Report Builder, and I now get the following error: 

aginatedReportAuthoringError: Report is invalid. ErrorCode: rsOutOfRangeSize, Details: The value of the Width property for the report section "ReportSection0" is "763.81705in", which is out of range. It must be between 0in and 455in.

I couldn't find any results from googling either of these errors. So please help. 

[Anonymous · Accepted solution]

Hi @dellison 

The error you're encountering in Report Builder,'PaginatedReportAuthoringError: Report is invalid. ErrorCode: rsOutOfRangeSize, Details: The value of the Width property for the report section "ReportSection0" is "763.81705in", which is out of range. It must be between 0in and 455in', is quite specific. It's indicating that the width of your report section exceeds the maximum limit that Report Builder allows. The maximum width for any report section is 455 inches, and your report section's width is set to 763.81705 inches, which is well beyond this limit.

1. Adjust the Report Width: Open the report in Report Builder. Check the properties of 'ReportSection' and adjust the width to be within the allowable range (0in to 455in). If you have multiple sections, you'll need to check each one.

2. Review and Adjust Column Widths: Since dummy columns are part of the design, review each column's width. If any of the dummy columns or other report elements have excessively large widths, reduce them accordingly.
   
   

3. Layout Considerations: If the report requires a wide layout to accommodate all columns, consider reorganizing the layout. This could involve grouping related columns closer together, using smaller font sizes, or abbreviating column headers. Another approach could be to split the report into multiple sections or pages if the data presentation allows for it.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi @dellison 

What I would suggest doing is to open your paginated report using Power BI report Builder, and then republish the report. That would be the easiest way and quickest way to resolve your issue.

[dellison]

Please re-read my post before replying 

"So i tried downloading it and editing it in Report Builder, and I now get the following error:"