Exporting to CSV from Power BI Service

Yes. Please see conversation started here a few days ago.

If Microsoft could just check it's not a problem their end, that would be helpful. It seems more than a coincidence to me that a limit of 30,000 has somehow become 300, if you see where I'm going with this.

I'm having the same issue. The table is not complicated with only 2 columns with integers, and 19.000 rows. When exported by .csv I get the same message (Data exceeds the limit), and the exported .csv is only 300 rows.

Hi , Anonymous 

Based on my research and previously handled cases, the limitation for the exporting from the Power BI service report may not only be decided by the 30000 rows limitation, for example:

When you're using DirectQuery, the maximum amount of data that Power BI can export is 16-MB uncompressed data. 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.
  
  What's more, if you are trying to export the data in the .xlsx format, the maximum number of rows that the applications can export to an .xlsx file is 150,000. The actual number may be lower than 150,000 depending on query limits and visual types.

For export from matrix visuals using Data with current layout, the export limit is 150,000 data intersections. For a table visual, each row has 1 data intersection. For a matrix visual, each row can have 1 or more data intersections, so the exported rows count can be less than 150,000. (For example, if a matrix visual has 3 data intersections per row, the maximum row count will be 150,000 / 3 = 50,000 rows.) The message "Exported data exceeded the allowed volume. Some data may have been omitted." will be added at the footer of the Excel file when the limit is hit. Consider limiting the dimensions or filter the data to avoid this scenario.

For more detailed information for the exporting part, please kindly refer to this official documentation:

Export data from a Power BI visualization - Power BI | Microsoft Learn

If you are still having this issue when overcame these limits, please kindly use the "F12" of your network browser to collect the network trace the the issue occurs and give the request ID for the detailed exporting process for my backend query.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

We're in the same boat over here.  Create a brand new table, load up a single column of 1,200 lines, and we get the "Data Exceeds the Limit" error.  The csv export allows 300 lines to get through.  This is beyond frustrating.  

Is there an export to Excel (instead of csv) function in Desktop that I'm unaware of?  

As of today it's working as it should! Successfully exported 7000 rows to .csv today. Thank you all for proving that I wasn't going crazy.