Power BI
CompletedIncrease the data export row limit (30,000 rows max) in Power BI Report Server
Ken Wetherell on 01 Feb 2018 03:41:30
The capability to export raw data from Power BI is an important function for many users.
Presently, the export data limits are as follows and confirmed at the community link below.
- Power BI Service (cloud platform): 150,000 row maximum
- Power BI Report Server (on-premise platform): 30,000 row maximum
Please increase the export limit setting on Report Server to match that of Service. Better yet, increase them both to a much higher limit as requested by others in separate idea posts.
http://community.powerbi.com/t5/Report-Server/What-is-the-Export-data-row-count-limit-for-Power-BI-Report/m-p/343951
Administrator on 05 May 2022 22:16:39
Thanks for your feedback - we are including the ability to Export to Excel from visuals with the Jan 2020 release, and this will up the export limit to the same levels as the PBI Service (150k rows).
- Comments (64)
RE: Increase the data export row limit (30,000 rows max) in Power BI Report Server
I like this idea.
Perhaps as well (since there will likely be some limit no matter what that users can hit), prompt the user that their desired export is being truncated, when they go beyond the limit.
RE: Increase the data export row limit (30,000 rows max) in Power BI Report Server
Hi Chris, any further progress?
For geo spatial applications using custom visuals 30.000 is really limiting.
RE: Increase the data export row limit (30,000 rows max) in Power BI Report Server
Hello Chris,
this is very fine. So we are hopeful to enhance the data export in our Power BI - Reports for our users in the future.
Thanks for your efforts!
RE: Increase the data export row limit (30,000 rows max) in Power BI Report Server
Users are interested in the reports to be downloaded in excel, please add this functionality in power bi report server.