The matrix cannot export the current layout

Hi Hann ,

• For export from matrix visuals using Data with current layout, consider the following:

  • Matrices with columns and/or values but no rows will be exported as having rows and/or values but no columns

  • Matrices with only one row and/or values but no columns will be exported as table (no right border separator)

  • If the Switch values to rows formatting option is set to 'On' in Power BI for a table or matrix visual, the visual format would not be preserved when data is exported to Excel

  • If the Row subtotals toggle is set to 'Off' in Power BI Desktop for a matrix visual, but the matrix visual has expanded and collapsed sections, exported data will contain subtotals for rows. To work around this issue, use the Expand | All command from the visual's context menu.

For more you may refer to :Export data from a Power BI visualization - Power BI | Microsoft Learn

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.