Skip to main content

Power BI

Completed

Increase Export Data Limits

Vote (1854) Share
Adam Wilson (POWER BI)'s profile image

Adam Wilson (POWER BI) on 24 Feb 2017 01:34:44

In late 2016, Power BI improved our export data options to allow exporting up to 150,000 rows to Excel from a visual on a Power BI dashboard for Pro users. If you require higher limits, please vote on this idea. If you have more specific requirements, please leave them in the comments.

Administrator on 01 Feb 2023 00:01:36

WWe ha a new feature that provides an increased limit of 500K rows of data to Excel from a Power BI visual. Learn more...Announcing Connected Excel Tables from Power BI (Public Preview) | Microsoft Power BI Blog | Microsoft Power BI

- Ikechukwu

Comments (178)
Adam Wilson (POWER BI)'s profile image Profile Picture

Haiyang Zhang on 26 Jan 2024 08:46:16

RE: Increase Export Data Limits

To be honest, 500K rows are not enough either. Could you consider to increase the limits to at least 1M rows? It could be an excel solution. I know there is a Beta 365 solution to connect and insert table from PBI to excel. But I tried several times, and only got up to 500K rows. Thank you!

Adam Wilson (POWER BI)'s profile image Profile Picture

Jeroen Budding on 20 Sep 2023 21:42:33

RE: Increase Export Data Limits

Would like to have these limits increased. For Enterprise companies the limit of 150k of devices or users is low. Add the moment we still need to use Tableau because off this limitation. If possible only modify it first for the Power bi on prem reporting server. These should have enough resources to export more records.

Adam Wilson (POWER BI)'s profile image Profile Picture

JH R on 20 Sep 2023 11:00:35

RE: Increase Export Data Limits

Export to Excel is current 150000 max. Pleaseincrease to max of Excel.In the operation we have now to export in badges, then combine then again in Excel. Extra work. Not needed.

Adam Wilson (POWER BI)'s profile image Profile Picture

David Bean on 02 Aug 2023 22:29:15

RE: Increase Export Data Limits

When a colleague told me about this limitation, I thought they must be mistaken. How can a modern reporting tool have such a limitation? I can't see how it could be a technical limitation, but I also can't understand why MS would decide to hamstring PBI in this way.

Adam Wilson (POWER BI)'s profile image Profile Picture

Michael Seim on 19 Apr 2023 17:17:29

RE: Increase Export Data Limits

I don't believe this is completed.Excel connections to PowerBI is a nice feature but it's not the same thing as increasing export limits.Firstly, the "Completed" solution requires uses to have "Build" rights for starters.Secondly, it's only available for "Summarized" data. That's of no use for exporting "underlying" data.From what I can tell the issue remains open and desired by many users. Please increase the underlying data export limit. Frankly, I don't see why Excel-export can't be 1M rows and CSV-export should be limitless.

Adam Wilson (POWER BI)'s profile image Profile Picture

Joji Antony on 21 Feb 2023 04:25:49

RE: Increase Export Data Limits

Please remove this limitation. We have many use cases where we want to allow the download of fairly large datasets. Not all of them are possible with the workarounds that are available right now. Please remove this limitation urgently.

Adam Wilson (POWER BI)'s profile image Profile Picture

Stephen Harrison on 01 Dec 2022 19:27:09

RE: Increase Export Data Limits

Others have said it best: this is a crippling limitation that defies explanation. In 2022, in the world of big data, where our not-even-big-data data sets are 10M+ records...we can export 150,000 rows.Competitor products are only limited by the space on your hard drive and the amount of time you're willing to wait - as it should be.

Adam Wilson (POWER BI)'s profile image Profile Picture

André de Lange on 13 Oct 2022 04:57:41

RE: Increase Export Data Limits

I have a current version of Power BI Pro and am using Desktop for doing data cleanup & transformations for data migration of an ERP system. Why can I only export 30K rows from a visual?

Adam Wilson (POWER BI)'s profile image Profile Picture

Owen Loughrin on 04 Aug 2022 17:53:06

RE: Increase Export Data Limits

This is a crippling limitation to an otherwise powerful tool. Downstream customers of reports frequently want to export data into Excel for on the spot analysis not anticipated in the published report. Simply put, this limitation makes this product uncompetitive with respect to other market leading software. Requests to increase export caps have been out there since launch of Power BI. It is hard to understand why this has not been addressed.

Adam Wilson (POWER BI)'s profile image Profile Picture

William Vinyard on 16 Jun 2022 16:32:59

RE: Increase Export Data Limits

CSV export should be unlimited by anything except remaining disk space on storage device selected for export.