Export Data to Excel - Export Data exceeded.

Hi RafaChaves_0591 ,

• When you're exporting data to Excel, the speed of download of the generated workbook can vary depending on network bandwidth.

• The maximum number of rows that Power BI Desktop and Power BI service can export to a .csv file is 30,000.

• 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.

More details: Export data from a Power BI visualization - Power BI | Microsoft Learn

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details.

 

Best Regards
Community Support Team _ Rongtie

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