Export Data to Excel - Export Data exceeded.

[RafaChaves_0591]

I'm having trouble being able to export all the data from a report in Power BI Service.

With the data already in excel, at the end of the worksheet, the following message is displayed: Exported data exceeded the allowed volume. Some data may have been omitted.

However, my spreadsheet has 20,000 records and in excel it only shows 7039.

Can I by any chance solve this through a configuration in my workspace or in the power bi service?

This is an organizational account.

[Anonymous · Accepted solution]

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.

[RafaChaves_0591]

Thank you very much for the information. I was able to come up with an idea and adjust my report.

[lokeshb31]

Hi,

We are facing the same issue and need to find a solution. Please let us know the adjustment you did to get the larger export working.

[RafaChaves_0591]

Hi. Unfortunately I didn't find another way to adjust the report. The user needs to split the query and extract the data. It is a choice to increase the number of parameters or decrease them and be able to extract more data. In my case it was like this. I would also like to know if there is another solution.

[j_flynn]

When you export from the Power BI Service, choose Summarized data and you will get a larger row max. 500,000 instead of 150,000.