Forum Discussion

newpbiuser01's avatar
newpbiuser01
Helper V
1 year ago
Solved

Error When Exporting Matrix Table in Excel

Hello,   I have a matrix table that loads without any errors in desktop and also when I load it in Power BI Service. However, when we try to export the table in Excel, I get an error saying there i...
Need Help
newpbiuser01's avatar
newpbiuser01
Helper V
1 year ago

Hi Anonymous 

I don't get that option, I only see Export Data which then brings me to "Which data do you want to export" where the file option is set to "xlsx" and is greye out. 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hello newpbiuser01 ,

 

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

 

I hope my suggestions give you good ideas, if you need any further assistance, feel free to reach out.

 

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

 

Thank you.