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,
Thanks for reaching out to the Microsoft fabric community forum.
As you mentioned in the post you are taking matrix table from the dashboard there are some limitations in dashboard exporting data.
- So, kindly try exporting the data to a .csv file. If you filtered the visualization, then the .csv export is filtered as well. Your browser prompts you to save or open the file. By default, your export is saved to your local Downloads folder and open the .csv file in Excel.
For detail information please refer to the below link:
Also, kindly review the data model for any unexpected data types or formats, particularly in your measures. Due to limitations in Microsoft documentation, you may encounter that error, so please refer to the image below.
Here are few similar example threads, please go through the links to get a better understanding.
https://community.fabric.microsoft.com/t5/Desktop/Exporting-a-Matrix-visual-to-Excel/td-p/1643080
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
Unfortunately, I can't export to .csv when I try to export the data. It's defaulted and set to "xlsx". I can't change it to csv. Is there a way we can change that?
Thank you!
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.
-