Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Matrix exporting

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.

Need Help
  • Icey's avatar
    Icey
    6 years ago

    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.

     

1 Reply

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    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.