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)

00603528 2f9c-4851-ab39-f6f49dc7d18f on 05 Jul 2020 23:35:34

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

Hello,
Any update?
Thank you.
Regards,
Pawel

65596a22 f8b0-4816-8b12-bf60865bfa44 on 05 Jul 2020 23:35:33

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

Hello,
are there any updates to this issue? We just had a PBI upgrade, and now have the 30k limit, which is causing many difficulties for us. This limit definitely needs to be removed. Thanks so much!

d67a9027 cac9-46e4-a8a9-088d5e780ab3 on 05 Jul 2020 23:34:27

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

Hello, any news about this limitation?
As can be seen, as a table option, for example, the option of number of lines per page, limiting each page to 30 thousand lines, but for data export this limit has to increase.

ceb7d690 2fcc-409f-8454-2b6ebad95206 on 05 Jul 2020 23:34:10

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

Hi Chris.
Are there any news about the increasing of the rows limitation? It would be better to introduce this improvement as soon as possible.
Thank you for your answer.

49d45f63 c21b-460e-afcd-b974831166c8 on 05 Jul 2020 23:32:52

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

Hello, any idea when the csv limit of 30.000 rows will change?

d89f7302 fb59-4d64-9e24-d3a6b1eac260 on 05 Jul 2020 23:32:50

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

Hi Chris,

Thanks for an update!!
Could you please help us know if this is already being implemented in the releases done so far?
If not, when is Microsoft planning to have this feature live.

Thanks in advance!!

06a2ff27 3a71-4404-863f-6a4709d3b0a7 on 05 Jul 2020 23:32:46

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

What is the status of increasing the limit of the export feature of Power BI Report Server on premise to export?

1f62169c cace-48fd-8a15-c40e357ca016 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.

4093fc74 c19f-4a42-9163-76c716671dfc 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.

def80d12 06a6-46ca-acb0-a2e425219f92 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!