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)

Jason Campbell on 06 Jul 2020 00:04:44

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

The limits(s) need to match excel. The ability to export to Excel from a visual seems like it should be a standard feature. Can someone please shed some light on the difficulty and/or reluctance to do so?

Qlikview exports to Excel almost perfectly. It's not even their product...

Shawn Benson on 06 Jul 2020 00:04:25

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

This is the number one complaint that we receive about Power BI from end users. It would be a game changer for us (and probably most organizations) if our end users were able to export embedded reports to Excel.

Power BI User on 06 Jul 2020 00:03:14

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

Hi Chris, We need answer please. Thanks

trevor savin on 06 Jul 2020 00:02:20

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

hi chris - this was under review all the way back in JUNE 2018... so I'm just wondering how long this is going to take to implement as I was proudly selling the capabilities of power bi to our business and this is like an egg in the face... the staff are transitioning from one bi platform to powerbi and due to data sensitivity we are not allowed in the cloud... has to be on-prem. I have 220,000,000+ records and whilst we are not wanting to export all I cant even get 000000.013% of the data to export... our staff are currently heavily reliant on excel, which i'm going to wean them off, but its going to take a long time (like how long before an office becomes paperless)... lifting this restriction will help us immensely - trev

Lee Cullom on 06 Jul 2020 00:01:53

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

A great and inexpensive way around this is to use canned Microsoft BI solutions from vendors like us, built on SSAS, for various enterprise applications. Have a look - https://northcraftanalytics.com - check out the YouTube channel for numerous examples.

Marty Case on 06 Jul 2020 00:01:22

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

make powerapp available on premise vs. cloud. We have a need to allow users to updating a column in the data while reviewing content in other columns in the data. I saw a way to do this with power app, but it is only available in the cloud. Need to do this on in house data. Cloud not an option for us. Thanks

Mary Barber on 06 Jul 2020 00:01:06

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

Any updates on this? Thanks!

Bobi on 06 Jul 2020 00:00:08

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

Hi Chris,

nice September release and the meantime quite disappointing that the announced feature (https://docs.microsoft.com/de-de/business-applications-release-notes/april19/business-intelligence/power-bi-report-server/export-excel-power-bi-reports) was not released in September

Could you provide an update on that ?

Thanks!

Bobi

rfh2001 on 06 Jul 2020 00:00:02

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

We are going to have to pull the plug on enterprise adoption of Power BI because of this! The ability to export large amounts of data is the single most important requirement for us. This is baffling to me.

Ludowik on 06 Jul 2020 00:00:01

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

Waiting for a long time for this feature, as the majority of the industry.

We are forced to implement static Excel reports in addition to Power BI reports. A mess.
Looking for others strategies