Getting one extra row while exporting paginated report to excel

[shamipathak]

THIS ISSUE IS RELATED TO POWER BI REPORT BUILDER: I have built a Matrix in PBI report builder (Paginated Report). Whenever I export the report to Excel, I get first row of every row group duplicated at bottom. This issue is not found when exported to other formats like PDF, Word, CSV.
Any help would be appreciated!

[v-jtian-msft]

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

It looks like you are having formatting issues when exporting the paged report from report Builder to excel, but not when exporting to other types of files.
This may be due to a difference in the paging settings in Excel compared to other formats, which is causing you to have extra rows when exporting to Excel (a layout problem).
Usually paged reports exported to excel are formatted for cells. Therefore you need to check the layout and paging settings of the report to ensure that they are compatible with Excel's formatting requirements (consistent with the formatting in Excel).
You need to double check the layout settings in the paged report as well as the visual size.

Please perform the following tests:
Modify the layout size of the matrix visual and try to reduce the size of the matrix.
In Power BI Report Builder, the layout of the matrix may affect the export results. Please make sure that the rows and columns of the matrix do not have merged cells and that the width and height of all cells are set appropriately.

I hope the following documents and issues can help you.

URL:
Export Power BI paginated report to Microsoft Excel (Power BI Report Builder) - Power BI | Microsoft...
Export Power BI paginated reports (Power BI Report Builder) - Power BI | Microsoft Learn
Solved: Paginated Report Export to Excel Formatting Error - Microsoft Fabric Community
Solved: Paginated Report: Excel Output as Tables - Microsoft Fabric Community

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.

[shamipathak]

Hi @v-jtian-msft, As the visual is matrix, and the rows are being grouped, I am getting merged cells. Also, the matrix is summarizing the groups and I am getting Summarized rows in duplicate rows (By default summarization is First) 

[v-jtian-msft]

Hi,@shamipathak .

Has your problem been solved?
If you have found suitable solutions, please share them as it will help more users with similar problems.
Or you can mark the valid suggestions provided by other users as solutions.
Thank you very much for your understanding and support of Power BI.

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

[v-jtian-msft]

Hi,@shamipathak .Thank you for your reply.

Thank you for your reply, you mentioned that you use aggregation and may need to merge cells, and excel formatting is cell based, so I think that is the probable reason for your problem. This is because operations such as merging cells destroy the desired layout in excel.
A better approach would be to try to modify the layout size as it is a limitation involving the layout of a paged report.

URL:
Export Power BI paginated report to Microsoft Excel (Power BI Report Builder) - Power BI | Microsoft...
Solved: Paginated Report Export to Excel Formatting Error - Microsoft Fabric Community

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.