Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Avinaash_S

Repeat row headers in a Power BI matrix while exporting data

Submitted by on ‎08-27-2024 08:13 AM

Currently it is not possible to repeat row headers in a Power BI matrix while exporting data.

You can repeat row headers Power BI matrix, but not while exporting data.


It is not possible to repeat row headers in a Power BI matrix while exporting data to Excel. When you export data from a matrix visual in Power BI, it exports the underlying raw data without repeating the row headers as they appear in the matrix. This behavior is consistent and by design in Power BI.


The export feature currently does not allow exporting the matrix data exactly as it is displayed in the matrix, especially with repeated row headers. This limitation is often discussed in the Power BI community, where users have expressed frustration with this feature.


It will be helpful, if the PBI Team gives the option to repeat row headers in a Power BI matrix while exporting data.


Please help us in this.

Status: New
See more ideas labeled with:
3 Comments (3 New)
Comments
fbcideas_migusr
New Member
‎02-25-2025 01:23 AM
Status changed to: New
 
PhilRead
New Member
‎05-06-2025 03:15 AM
I would also like a solution for this. When exporting the matrix to Excel, selecting "Summarized Data" removes the matrix and puts my column as a row and if I select "Data with Current Layout" all my rows come out merged. I can unmerge the cells but it is not a good customer experience for the user.
Loga
New Member
‎07-28-2025 08:22 PM
Similar idea has been posted on https://community.fabric.microsoft.com/t5/Fabric-Ideas/While-exporting-the-matrix-visual-into-excel-...