Skip to main content

Power BI

Completed

Increase the data export row limit (30,000 rows max) in Power BI Report Server

Vote (986) Share
Ken Wetherell's profile image

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)
Ken Wetherell's profile image Profile Picture

Kevin on 05 Jul 2020 23:32:13

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.

Ken Wetherell's profile image Profile Picture

Power BI User on 05 Jul 2020 23:29:05

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.

Ken Wetherell's profile image Profile Picture

Bodo Rauch on 05 Jul 2020 23:21:29

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!

Ken Wetherell's profile image Profile Picture

Power BI User on 05 Jul 2020 23:13:00

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.