Error When Exporting Matrix Table in Excel

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:

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-service#considerations-and-limitations

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.