Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
8 years ago
Solved

Export Data - Data Exceeds the Limit

Hi,   I suspect this comes with the November update. When I try to do an Export Data from a Matrix or Table I am now getting a Data Exceeds the Limit error, I used to be able to Export data with a ...
Need Help
  • TomMartens's avatar
    TomMartens
    8 years ago

    Hey,

     

    the documentation states that there is a limit of rows that can be exportet to csv, this limit is 30000 rows.

     

    Using the target format xlsx this limit is 150k rows, the export to xlsx option is available in Power BI Service.

     

    These limits are described here:

    https://docs.microsoft.com/en-us/power-bi/power-bi-visualization-export-data

     

    Please don't ask me why such a limit exists :-) I'm just the messenger

     

    Regards

    Tom

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
8 years ago

What more I have observed is that if it reaches a certain number of rows, it removes duplicate columns which I intentionally placed but if it's less rows it just leaves duplicate columns alone.

 

So probably I could say it does not truncate by rows(to a certain number maybe 30K or 100K) but it certainly does remove duplicate columns.

alex139's avatar
alex139
Frequent Visitor
8 years ago

ovetteabejuela

I will test this tomorrow morning. If you have any datasets you have used in your tests please share. Thank you.