Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
RafaChaves_0591
New Member

Export Data to Excel - Export Data exceeded.

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.

RafaChaves_0591_0-1687972877660.png

 

 

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

This is an organizational account.

 

1 ACCEPTED SOLUTION
v-rongtiep-msft
Community Support
Community Support

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.

View solution in original post

4 REPLIES 4
v-rongtiep-msft
Community Support
Community Support

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.

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

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.

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors