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

Power BI User on 05 Jul 2020 23:54:08

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

would also vote on this idea

export limits must match the excel limits of 1000000 rows

Ken Wetherell's profile image Profile Picture

Power BI User on 05 Jul 2020 23:53:28

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

Increase the data export row limit

Ken Wetherell's profile image Profile Picture

John Qiu on 05 Jul 2020 23:50:19

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

Please work on this idea. Ad hoc requests require the raw data. Can't build a tab in reports for each request.

Ken Wetherell's profile image Profile Picture

Earle Lindfors on 05 Jul 2020 23:49:07

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

Very difficult to advocate for this product to support the "Enterprise" with this kind of limitation on export. With migrations to Windows 10 builds 1709 and 1803 of interest to DOD, this capability is perfect for tracking progress. However, when looking to take action on the results (which will certainly exceed 30K records) during the initial phases, it renders the capability short of supporting Enterprise requirements. PLEASE put your best engineers on this issue ASAP. PBIRS is too powerful and valuable not to.

Ken Wetherell's profile image Profile Picture

Onboarding User on 05 Jul 2020 23:48:45

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

We must be able to have the limits of Excel in the extraction, this is must for us since we have a lot more lines of what we are able to extract for the moment!
Please look in to this feature for the benefit of all of us!

Ken Wetherell's profile image Profile Picture

Sadhya on 05 Jul 2020 23:48:44

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

YESSS! This is so important it is a deal maker or breaker. What do you do with this massive fabulous tool when your reports aren't complete because it can't handle the download? Match the 2016 Excel limit.

Ken Wetherell's profile image Profile Picture

Power BI User on 05 Jul 2020 23:48:43

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

Both report server and service and PBIX desktop should have much, much higher export limits, for both CSV and Excel. Currently... service (150K, csv/Excel); report server on prem-platform (30K); PBI Desktop (30k, csv)

Ken Wetherell's profile image Profile Picture

Carlos Brenes Víquez on 05 Jul 2020 23:42:52

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

We would like to share our reports on a wider basis and to maintain them on one central place, but we need to increase the download limit on the web-platform of the Power BI server.

Ken Wetherell's profile image Profile Picture

Anna Whisenhunt on 05 Jul 2020 23:42:52

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

I second the request to increase (or eliminate) the limit on the report server. Our business processes more than >30000 transactions at once; while there is a work around, it is disruptive and time consuming.

Ken Wetherell's profile image Profile Picture

Markus on 05 Jul 2020 23:42:51

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

Please increase the download limit on the report server. I guess it has been set to not reduce performance but if it's running on an own server environment it would be good to let the customer decide what is more important - speed vs quantity. I suggest to make the download limit part of the customization of each individual Power BI report server admin.