Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Icon for Impactful Individual rankImpactful 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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

ovetteabejuela,

I can reproduce your issue in November update. Based on my test, the message will throw when you export >=500 rows data. When your visual contains >=500 rows data, as long as you click "Continue" button, the data will be exported in CSV properly.

Besides, I will report this issue internally and post back once I get any updates.

Regards,
Lydia

ovetteabejuela's avatar
ovetteabejuela
Icon for Impactful Individual rankImpactful Individual
8 years ago

Thank you for looking and kindly post back. Okay so the "Continue" option will not truncate anything?

 

As of now I recreated everything in Excel PowerQuery just for that portion where we need the data exported in CSV.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    ovetteabejuela，

    When I test with 10000 rows and use Export data option, the data are not truncated, but for the specific limit, we still wait for PG's response.

    Regards,
    Lydia