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 😞
Hi newpbiuser01,
After creating your dashboard, you will find a three-dot menu. Within this menu, there is an option labelled "Export to CSV," which allows you to export your matrix table.
To provide clarity, I am including a screenshot of the location from which we need to export the data.
As demonstrated in the image above, click on the 'Continue' option, and the data will be downloaded to your local system.
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
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.
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.
-