Matrix exporting

[Anonymous]

I am using PowerBI pro account and i am unable to export matrix visual data as excel file.

There are less than 150000 rows in the matrix.

The file size is also less than 1MB.

If I delete any one of the row/ column from Matrix then the exporting is working fine.

[Icey · Accepted solution]

Hi @Anonymous ,

Maybe this is the cause:

---

An unintended result may be that you export less than the maximum number of rows of 150,000. This is likely if:

• There are too many columns. Try reducing the number of columns and exporting again.

• There's data that is difficult to compress.

• Other factors are at play that increase file size and decrease the number of rows Power BI can export.

---

Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#limitations-and-considerations.

Best Regards,

Icey

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