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 30 Jul 2020 16:56:47
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 (158)
RE: Increase Export Data Limits
Definitely support a higher limit. Also, why can't I export to XLSX from a table when no aggregates are in the table?
RE: Increase Export Data Limits
Removing the limit would be a huge step to give Power BI even more power and to become a stronger alternative to Tableau
RE: Increase Export Data Limits
Major roadblock to convincing decision makers about the efficiency of using Power BI when compared to other platforms. Please remove this constraint --
RE: Increase Export Data Limits
This limit is a major blocker for using PowerBI with my Investment Banking client, many of their reports need to go out to customers in Excel format and can be up to 300k records, I presume this issue is related to limiting memory resources on the server? Can this not be overcome?
RE: Increase Export Data Limits
We are really limited on rolling this out due solely to this issue.
It is also odd that there is no warning (at least when exporting from a matrix). My data stopped around 38k rows (there was supposed to be 200k) and I only happened to notice because the totals were off.
RE: Increase Export Data Limits
Definetively, improving export limits will become very useful when working with lots of data, since I need my team to action several reports for more than 150K lines. Totally love Power BI, but that is something Tableau can do and Power BI cannot.
RE: Increase Export Data Limits
1MM rows please
RE: Increase Export Data Limits
Increasing (or removing) this limit would certainly take our usage of power bi to the next level with the combination of the efforts from several of our teams. Excited to see increased integration of Power BI and R!
RE: Increase Export Data Limits
will these limits be extended to Power BI Reporting Services as well. And also in the Power BI SSRS executable?
RE: Increase Export Data Limits
The use of * programming with PBI would benefit greatly from increasing this limit to way higher numbers. 150.000 is a real constraint if you have to work with higher frequency data.