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

TomMartens's avatar
TomMartens
Super User
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

zhou23's avatar
zhou23
New Member
7 years ago
How do I change export format to excel?
  • LY18's avatar
    LY18
    Helper I
    7 years ago

    Hello,

     

    still get the same issue with version of april 2019 .... the data are troncated at 30000 rows for csv files from the desktop .... i don't understand what is the idea behind limiting the file size but it's clearly painful

     

    i've heard that i should be able to export to XLSX from the sevice (up to 150000 row) but i couldn't find the option

    Can you help me?

     

    thanks

    • zhou23's avatar
      zhou23
      New Member
      7 years ago

      LY18 , you can't access Excel option from Power BI dev app. You can see it only from the published report. So save, publish, go to report url, then the export pop up will ask which format.

    • Shelley's avatar
      Shelley
      Post Prodigy
      7 years ago

      LY18 Once the report is published to powerbi.com, hover over the visual you want to export and three dots should appear in the upper right corner. You can then select Export and continue exporting to Excel file format.

       

      • LY18's avatar
        LY18
        Helper I
        7 years ago

        thanks for both feedbacks ;-)