Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
Solved! Go to 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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
32 | |
26 | |
23 | |
19 | |
15 |
User | Count |
---|---|
51 | |
38 | |
24 | |
20 | |
20 |