Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
dataexplorer123
Frequent Visitor

Paginated Report showing different values for the Row Group when seen in Print Layout or in PDF

I have created a report on Power BI Report Builder (Paginated Report Desktop). When run it by inputting the parameter values it shows correct information for each of the groups but when I convert it into PDF or any other formats it repeats the first group values. Though, it gives correct values when exported into CSV or MHTML formats. I have no idea what am I doing wrong.

Without Print Layout

dataexplorer123_1-1729619446525.png

 

With Print Layout I get to see the first group value get repeated on page 2

dataexplorer123_2-1729619513417.png

This how csv file looks like:

dataexplorer123_3-1729619589742.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi,@dataexplorer123 .Thank you for your reply .
Have you tried not inserting a separator in a table/matrix group where the problem also occurs. From there, determine if the problem is due to incorrect use of separators.
I would recommend not inserting separators into groups, as paged reports are exported to PDF in a strict layout setting, and setting the layout in this way may lead to unexpected export results.
URL:
Rendering behaviors in a Power BI paginated report - Power BI | Microsoft Learn
Pagination in Power BI paginated reports - Power BI | Microsoft Learn

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi,@dataexplorer123 .I am glad to help you.

According to your description, you have a problem exporting a report you created using Power BI Report Builder to PDF:

You create a paginated reports in Power BI Report Builder and filter the data by entering parameter values. The report displays the correct information on preview and the data in each group is as expected.
When the user exports the report to PDF or another format, such as Excel, the report displays the data incorrectly. Although the actual filtering results and preview results are correct, the first group's data is displayed repeatedly in the exported PDF.
But when you export the report to CSV or MHTML format, the exported data is correct and there are no duplicates or errors.
Also when viewing the report in a print layout, the user notices that the data from the first group is duplicated on the second page.

 


I have tested the situation you are experiencing

When I created the matrix grouping and used the export topdf feature in Power BI Report Builder several times, there was no problem!
Here are the results of my  tests
In Power BI Report Builder:Export to PDF

vjtianmsft_0-1729664789250.png

vjtianmsft_1-1729664799601.pngIn Power BI Report Server

vjtianmsft_2-1729664829643.png
In Power BI Service

vjtianmsft_3-1729664854015.png

The final results are all normal and there are no cases of errors in the exported results.

vjtianmsft_4-1729664880638.png

Try printing the problem report on different platforms (Power BI report Builder,Power BI Report Server, and Power BI Service) and see if this problem occurs. In order to determine whether there is a problem in the design layout of the report itself, or a problem in the export function of a certain platform software.

Here are my suggestions for your question:
1. I recommend that you review the layout interface of your paging report design to make sure that each page preview appears properly
PDF export requires consideration of the visual layout and paging of the report, which can result in repeated data display. Make sure that the report is paginated correctly to avoid repeating data when paginated (or blank pages when exported).
Parameter application problems: Parameters may not be applied correctly to all pages or groups when exported. Please check the parameter Settings to ensure that they are applied correctly when exporting.
2. power BI report Builder may be a problem, please check the version of the report Builder and try to update it to the latest version.

Note that exporting to PDF is different from exporting to CSV or MHTML.
The PDF format is a physical page renderer that strictly follows hard paging rules. This means that PDF exports take into account page size and layout, which can lead to data paging and display issues.

When exported to CSV, the data is presented as plain text, regardless of layout paging, and is not affected by paging Settings.
You need to rigorously calculate the layout specifications of the report when exporting to PDF

The following is a page report layout design and export to PDF related documents, I hope to help you.
URL:
https://learn.microsoft.com/en-us/power-bi/guidance/report-paginated-blank-page
Export Power BI paginated report to a PDF File (Power BI Report Builder) - Power BI | Microsoft Lear...
Paginated reports in Power BI: FAQ - Power BI | Microsoft Learn
 

vjtianmsft_5-1729664961875.png

vjtianmsft_6-1729664969190.png

If possible, please provide a more detailed description of the report layout and corresponding screenshot of the export problem, which will help to locate the specific cause of the error (a problem with the report layout design or an issue with the platform functionality).


I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you for your prompt response. I really appreciate it! 
I have checked my report for all the aforementioned possible errors. Still facing this issue. For further understanding of this situation. I have attached the demo dataset along with my paginated desktop file.

https://drive.google.com/file/d/1-FoMfZSFRAoJbsV5mTp5EuaKgepPii8B/view?usp=drive_link

I just figured out this issue appears when I select the page break option on  the row/column group properties.

Anonymous
Not applicable

Hi,@dataexplorer123 .Thank you for your reply .
Have you tried not inserting a separator in a table/matrix group where the problem also occurs. From there, determine if the problem is due to incorrect use of separators.
I would recommend not inserting separators into groups, as paged reports are exported to PDF in a strict layout setting, and setting the layout in this way may lead to unexpected export results.
URL:
Rendering behaviors in a Power BI paginated report - Power BI | Microsoft Learn
Pagination in Power BI paginated reports - Power BI | Microsoft Learn

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.