Forum Discussion
Getting one extra row while exporting paginated report to excel
Hi Anonymous, 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)
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 Learn
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.