Exporting to CSV from Power BI Service

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