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

David Wakeman on 05 Jul 2020 23:41:42

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

Hey Chris, can you provide an update since you mentioned in July 18 that it would be in an upcoming release. We're tuned, wired and set on this channel. What is the word on the street?

Ken Wetherell's profile image Profile Picture

Power BI User on 05 Jul 2020 23:41:32

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

Hello,
When could it be expected? It is very important for our company...

Ken Wetherell's profile image Profile Picture

John on 05 Jul 2020 23:41:12

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

vote +1

Ken Wetherell's profile image Profile Picture

Stine on 05 Jul 2020 23:40:17

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

There should be no limits!!

Ken Wetherell's profile image Profile Picture

Manish Siwach on 05 Jul 2020 23:39:22

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

Hi Chris, Any update on lifting the 30k limitation on Power BI Report Server. Earliest reply is of great help for us to decide on Power BI or Tableau.

Ken Wetherell's profile image Profile Picture

Kenny Miller on 05 Jul 2020 23:38:45

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

Hello all,

We are excited about what Microsoft is doing in the space of data visualization but it would be very beneficial to our customers to increase the export limitation to 150,000 rows. Can you please update us on the status of this item. How many votes do we need?

Ken Wetherell's profile image Profile Picture

Liam Newlin on 05 Jul 2020 23:38:41

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

Hi Chris,

Do you have any updates on removing the row restriction when exporting from PBI RS?

Thanks,
Liam

Ken Wetherell's profile image Profile Picture

eric pittman on 05 Jul 2020 23:37:16

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

This is really limiting the usability of Power BI Report Server - Please update.

Ken Wetherell's profile image Profile Picture

Jeff Messer on 05 Jul 2020 23:37:07

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

One more bump on this, first posted in January, Chris commented mid-year, it's now December...lifting these kids of limits really should be a priority.

Ken Wetherell's profile image Profile Picture

ChienNH on 05 Jul 2020 23:37:02

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

Please update