Skip to main content

Power BI

Under Review

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

Vote (851) 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 14 Dec 2019 08:13:11

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

70b86fdd 02d2-46e4-bad3-66cee90e6ae8 on 05 Jul 2020 23:59:23

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

We want this functionnality! Any update?

Ken Wetherell's profile image Profile Picture

70b86fdd 02d2-46e4-bad3-66cee90e6ae8 on 05 Jul 2020 23:59:18

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

For power bi report server, you must add a variable configuration in order to limit the data row export to csv file : so, each organization can limit the export csv.

Ken Wetherell's profile image Profile Picture

70b86fdd 02d2-46e4-bad3-66cee90e6ae8 on 05 Jul 2020 23:59:07

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

70b86fdd 02d2-46e4-bad3-66cee90e6ae8 on 05 Jul 2020 23:59:07

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

There is news for this limitation?

Ken Wetherell's profile image Profile Picture

7e2000e4 f1d0-4806-8598-81cef5e83434 on 05 Jul 2020 23:58:30

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

It would be helpful to increase this limit to a good higher number if possible

Ken Wetherell's profile image Profile Picture

d4c9337c 0770-4fbf-b277-d966a2e34593 on 05 Jul 2020 23:58:29

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

Any update?

Ken Wetherell's profile image Profile Picture

b8bcaf83 9b92-4154-83f6-0a9497a0d53c on 05 Jul 2020 23:56:50

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

Hello Chris, We had to change our data access methods and architecture because of this limitation. Any update on increasing the download limit?

Ken Wetherell's profile image Profile Picture

a4e95a07 3c79-45be-ba12-375494924183 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

aaf815b9 2b3d-42d3-95dc-2d1595ec7b48 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

087bbd7f c788-4509-8099-db4103d28aab 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.