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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Anonymous
Not applicable

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

5 REPLIES 5
Anonymous
Not applicable

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.

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.

j_flynn_0-1733415346818.png

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.