Forum Discussion
Error When Exporting Matrix Table in Excel
Hello,
As I mentioned in my comment earlier, I have raised it as an issue which is still being investigated:
Exporting Matrix Table with Dynamic Formatting Thr... - Microsoft Fabric Community
Unfortunately its not been resolved yet 😞
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.
Hi Anonymous ,
But this still wouldn't help me export the data in .csv so I don't get the error while exporting in Excel. How would I do that?
Hello newpbiuser01 ,
As I mentioned in my previous response, there are limitations when exporting the matrix visual to Excel. Therefore, exporting it to CSV might be the best approach for you.
Could you please include a screenshot of the error you encounter when exporting it to CSV?
Thank you.
Hi Anonymous,
I can't export to csv, that's the problem. The file format is greyed out and locked. I can't change it from Excel.
This is also an issue if I'm exporting a table visual with more than the 150,000 row maximum. How can I change this setting to be able to export to csv?
Hello newpbiuser01 ,
Thank you for providing detailed information, and I apologize for the late response.
To clarify, as you mentioned in your initial query, you referred to the dashboard. I have already explained that there are limitations when exporting a matrix visual to Excel from the dashboard, which is why I recommended exporting it to CSV instead.
From the screenshot you provided, it appears that you are exporting data directly from the report rather than the dashboard. Please try exporting the same matrix visual from the dashboard, where you will see the option to export to CSV.
So kindly look into the consideration in the following documentation:
Regarding your second query, exporting a table visual with more than 150,000 rows may not be feasible. According to Microsoft documentation, the maximum number of rows that can be exported to an .xlsx file is 150,000. However, the actual limit may be lower based on query limits and visual types.
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.