Forum Discussion
Paginated Report: Service - Null Page Between Table Results
Hi c_cook28954 ,
Thanks for the update.To reduce unnecessary white space while preserving the logic for showing or hiding objects in a Power BI paginated report, consider the following approach:
Use the “Consume container whitespace” property by setting it to True. This helps minimize white space that may appear when certain report elements are hidden.
Additionally, place the items you plan to show or hide inside rectangles. Rectangles act as layout containers, and when the objects within them are hidden, the rectangle can collapse accordingly—further reducing blank space and maintaining a cleaner report layout.
Refer to the Troubleshoot paginated report execution issues - Power BI | Microsoft Learn
Add empty points to a chart in Power BI paginated report - Power BI | Microsoft Learn
Empty and null data points in Power BI paginated report charts - Power BI | Microsoft LearnIf our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithra.
Hi c_cook28954 ,
Thank you for reaching out to Microsoft Community.
This issue usually occurs due to mismatch between the content size (width/height) and the report page size or margins. Maybe Your report body or items inside it like tables, textboxes, etc. exceed the printable area of the page.
Check page width vs body width.
Check table and other items alignment, ensure that left + width ≤ usable width.
Remove invisible objects like blank rectangles or hidden textboxes.
For the table, set Keeptogether = False, Keepwithgroup = None, remove explicit page breaks.
Temporarily reduce page margins to 0.25in on each side and see if the blank page goes away. If yes, you’re definitely dealing with a sizing overflow.
Reference: Avoid blank pages when printing paginated reports - Power BI | Microsoft Learn
If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.
Thanks,
Chaithra E.
Hi v-echaithra
Thanks for the response.
In order to test all your suggestions as efficiently as I could, I created a copy of my report and stripped everything out aside from one of the tables. I then reran the report several times after each of your suggestions, here's what I found:- Removing blank/invisible objects: None existed on the page, so no difference
- Set Keeptogether = False: Already tried, no difference
- Set Keepwithgroup = False: Couldn't find this function
- Check table alignment: Reduced the size of the table by 30mm and found no difference
Original Width: 265
Original Location (Left): 10
Altered Width: 235
Altered Location (Left): 10 - Check page width vs body width: Well within the limitations, especially considerating the width adjustment in the previous step.
Page Width: 29.7cm
Length Used: 265mm + 10mm = 275mm - Alter page margins: This was the only change that worked - I reduced them to 0.5 and the tables load fine, albeit very close to the top
My issue now is that I have extremely slim margins at the top of the tables and still appear to have some whitespace beneath them that I can't take advantage of. Do you have any suggestions for how to fix this given altering the visual's size hasn't made any difference?
