The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
With Print Layout I get to see the first group value get repeated on page 2
This how csv file looks like:
Solved! Go to Solution.
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.
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
In Power BI Report Server
In Power BI Service
The final results are all normal and there are no cases of errors in the exported results.
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
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.
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.