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)
RE: Increase Export Data Limits
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.
RE: Increase Export Data Limits
150000 seems random. Need more than this.
RE: Increase Export Data Limits
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
RE: Increase Export Data Limits
As per all the comments below. Microsoft please sort this issue. It is a massive bottleneck and limitation of power bi.
RE: Increase Export Data Limits
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.
RE: Increase Export Data Limits
this limit is ridiculous and creates a lot of non-value added work. Please increase ASAP.
RE: Increase Export Data Limits
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.
RE: Increase Export Data Limits
Tableau has no limitation on row export. Please remove the export limit of 150,000.
RE: Increase Export Data Limits
Please change/remove the rowlimit on exports from Power BI reports to csv -> unlimited and excel -> 1,048,576 (maybe -1 for the headers). End users need to be able to perform their own analysis / checks (for example in Excel) on the source data.
RE: Increase Export Data Limits
As other partners provided comments, even our Organization's users facing huge difficulty in performing this basic reporting operation due to its limitation. It was really frustating for the users to do the tedious work of getting export through drill-throughs/paginated reports/applying filters with multiple extracts. So requesting you to kindly look into this idea's implementation.
It's also not fair that idea won't be considered for implementation unless it reaches 2K limit. Atleast it should not be the case in providing the basic reporting functionalities. Hope this functionality will soon flow into Power BI. Also requesting the TAM to raise DCR with the filled Business Impact Document