Power BI

Completed

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

Vote (986)

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)

Comments (64)

Robert Trupschuch on 05 Jul 2020 23:59:57

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

Yes very disappointing - all our users waiting for this. Our company strategy is at risk.

Robert on 05 Jul 2020 23:59:57

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

Will we have to wait for January for this feature? It said in this article that it should be released in September but I don't see it. https://docs.microsoft.com/sv-se/business-applications-release-notes/April19/business-intelligence/planned-features

Nikolay Marchuk on 05 Jul 2020 23:59:57

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

It's been a year. There were 3 releases. And still export to EXCEL is not added.

Power BI User 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?

Power BI User 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.

Power BI User 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

Power BI User 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?

Binyam 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

Jorge SM 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?

Siva Nallaswamy 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?