Power BI

Under Review

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

Vote (851)

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)

Comments (61)

df7de66d 45e0-49ca-8287-562a92c7c2e2 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!!

60507525 3d24-42de-b9fe-c5d7b699617a 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.

38f74866 3b4e-4d75-9f98-b6efbc9d426e 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?

278efe96 e9ce-431d-af8e-6840ac38dddd 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

78d6034d b110-4758-bcd3-bbc653c68345 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.

ea5ae7f9 2efe-450c-8032-6e00196e6c1b 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.

906f07b5 2348-4daa-b82d-66603dbbefd9 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

9007a537 c421-4885-ab3d-c1fee83c9c7f on 05 Jul 2020 23:36:57

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

PowreBI is very limiting in what it can do. Tableau on the other hand can export 1M rows vs PowerBI is limited to 30K rows. I don't get why Microsoft provides tools which are so half baked.

cd7b9008 2f58-425f-8150-61c2d2297c5b on 05 Jul 2020 23:35:58

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

Power BI is the lovely tool for the end users and business admins. Exporting to excel is very critical functionality for bank branches

Thanks for your support.

f0de617c 90a8-4375-a9d9-2c6421cb041f on 05 Jul 2020 23:35:38

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

Any update ?
All settings we put on previous version are now completely unuseful due to this limitation