Increase Export Data Limits

[adamw1]

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.

[adelange]

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?

[Stephen_Harriso]

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.

[nishalit]

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 | Microso...

- Ikechukwu

[joji_antony]

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.

[michael_seim]

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.

[DBean1]

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.

[jan_henk_raap1]

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.

[Jeroen_Budding]

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.

[zhanghy76]

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!

[Abhishek_Chanda]

This is very restricting limitation. It has been a major roadblock for us to move all our reporting to PBI and decommission our legacy reporting system. Any modern tool should allow at least 1 million row export limit.