Forum Discussion
Export and Print Excel from Power BI Report Builder
Hi NicoleR ,
Please try below things to fix the issue.
1. Even with perfect alignment, Excel may still merge cells due to, Slight differences in Y-position or height of adjacent elements. Autofit Width settings in headers.
Solution: Manually set identical height and Y-position values in the properties pane for all elements. Avoid “Autofit Width” where possible.
2. Excel does not fully support repeating matrix headers across pages. Consider duplicating headers manually in the dataset or using Excel macros post-export.
3. when CanGrow = False, but Excel may still wrap or merge if Padding is inconsistent. Text alignment is not uniform.
Solution: Set Padding = 0 and use TextAlign = Center or Left consistently. Avoid overlapping or tightly packed textboxes.
Please refer Microsoft offical document and community thread.
Solved: Paginated Report Export to Excel Formatting Error - Microsoft Fabric Community
Regards,
Dinesh
Super UserHi NicoleR ,
Achieving your specific formatting requirements when exporting from Power BI Report Builder to Excel is entirely possible, though it requires a different approach than formatting for a PDF export. The core issue stems from the fundamental difference between the two formats: PDF is a fixed-page layout that preserves visual design exactly, whereas Excel is a flexible grid-based spreadsheet. Because of this, you must adjust specific report properties that target the Excel renderer to get the desired output.
To make your matrix headers repeat on each printed page in Excel, you need to configure the properties of the tablix (the matrix object) itself, rather than relying on the report's page header. You can do this by navigating to the "Grouping" pane in the Report Builder designer. From there, access the "Tablix Properties" for the static row group that contains your headers. Within these properties, you will find and need to check the option to "Repeat header rows on each page." Setting the FixedData property of the header row to True will also ensure the headers remain visible when scrolling within Excel.
For controlling how text appears in the cells, you can prevent it from wrapping and instead force it to be truncated. This is managed by changing the properties of the text boxes inside your matrix. Select the cells you wish to modify, go to the Properties pane, and set the CanGrow property to False. This action stops the cell's height from expanding to accommodate long text, effectively truncating it to fit within the original cell dimensions.
The common problem of merged cells in an Excel export is almost always caused by slight misalignments between different items in your report layout. To ensure each matrix cell exports as a single Excel cell, you must achieve perfect alignment. Every element, from the text boxes in your page header to the matrix in the body and any items in the footer, must have identical starting positions and widths. Use the alignment tools in Report Builder to align the left and right edges and match the widths of your objects precisely. Manually checking the Location and Size properties for each item can help you find and fix tiny discrepancies. Removing any empty white space between these report components is also a crucial step to prevent unintended cell merging.
Finally, to make the exported file print-ready, applying the above fixes for headers and cell structure will handle most of the work. You can further refine the print layout by setting the report's overall page dimensions. By clicking on the report background to select the report object, you can access its PageSize and Margins properties. Adjust these to match your target paper size, such as Letter or A4, which will pre-configure the print settings in the exported Excel file for a seamless printing experience for your users.
Best regards,