Comments
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.
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.
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?
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.
CSV export should be unlimited by anything except remaining disk space on storage device selected for export.
The limit needs to be removed on both Excel and especially CSV. Although there are workarounds (like the paginated report or Analyze in Excel), the limitation is arbitrary and should either be removed, or make it an admin setting that can be controlled by the organization.
150000 seems random. Need more than this.
Was wondering if there were updates on this? But I noticed that this does not seem to be showing in the Power BI Ideas list...
The business is reporting trouble with exporting data with the 150,000 rows - particularly even after filtering etc - the data is just over the limit - it is very frustrating
As per all the comments below. Microsoft please sort this issue. It is a massive bottleneck and limitation of power bi.
This is such a massive bottleneck for Powerbi. I can't believe the dev team hasn't been able to figure out to allow more than 150k export by now.
Administrator on 2/1/2023 12:01:36 AM
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