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

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.

Ken Wetherell's profile image Profile Picture

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

Ken Wetherell's profile image Profile Picture

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.

Ken Wetherell's profile image Profile Picture

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?

Ken Wetherell's profile image Profile Picture

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.

Ken Wetherell's profile image Profile Picture

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

Ken Wetherell's profile image Profile Picture

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?

Ken Wetherell's profile image Profile Picture

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

Ken Wetherell's profile image Profile Picture

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?

Ken Wetherell's profile image Profile Picture

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?