1783
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.
STATUS DETAILS
Needs Votes

There are longer term plans to allow larger exports in that use case, but there isn't a current timeline as to when that will be available. Customers who have Power BI Premium can set a drill-through to paginated reports via URL parameters as a workaround in the interim, as there is no data export limit for paginated reports.

Comments

A

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?

A

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.

A

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

A

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.

A

150000 seems random. Need more than this.

A

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

A

As per all the comments below. Microsoft please sort this issue. It is a massive bottleneck and limitation of power bi.

A

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.

A

this limit is ridiculous and creates a lot of non-value added work. Please increase ASAP.

A

Are there any plans to increase data export limit this year? Tableau doesn't have any export limitations, so it's very unfortunate to have this bottleneck in PowerBi. If performance impacts are the issue, then there should be an option for the developers to chose and adjust the data export functionality.