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 o...
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.

     

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.