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
Voted.
Meanwhile you may have a look at "Analyze in Excel" external tool from SQLBI. It removes the limit. In the future, it will allow to use Excel templates to setup a personalized export.
RE: Increase Export Data Limits
Absolutely.
Currently have to use workarounds such as DAX Studio for csv, which handle exports flawlessly. Where as Power BI limit you to 30k rows for CSV as well as 150k rows for excel, which is on the same Microsoft Platform. Shocking to say the least.
RE: Increase Export Data Limits
I don't know the reason behind this export limit is, but whatever the reason is, it's makes the application so useless.
Tableau doesn't have any export limitation and even though POWER BI has several advantages over Tableau, this single limitation makes it near useless as we may have to re-evaluate the use of Power BI in my organization.
RE: Increase Export Data Limits
Many common operational needs exist for 150k+ row export for our Pricing and Finance teams.
RE: Increase Export Data Limits
This is a major limitation, which is causing us to reevaluate the use of PBI. All of our customers have "export underlying data" as a basic requirement. Tableau allows user-friendly crosstab exports of over 33 million cells (or 1 million records of a 33 column table). If you hope to compete with Tableau and retain business, this should be a top priority (instead of forcing our report builders and users to jump through additional hoops with drill-through and paginated reports).
RE: Increase Export Data Limits
Microsoft - PLEASE ADDRESS THIS ASAP.
Alternative solutions are not feasible at all.
For Eg we evaluated Paginated Reports - very basic, It has its own limitations
Embedding Report in App to overcome this limit?? Seriously? Then what is the purpose of having one central portal. How many report should we embed?
RE: Increase Export Data Limits
Have just found out there is a limit of 150,000 rows when exporting to excel? We are trying to switch reports from another reporting tool (not the reporting tool mentioned in a previous comment) which does not have this limit at all and exports to excel without any problems.
RE: Increase Export Data Limits
Hello Power BI team. This 150,000 limit on row export is a deal breaker. The end users in my organisation are already complaining about this. We have accounting and GL level transaction dashbaord for our end users. For YTD data the exports are often more than >150k. Please guys work through it to allow more rows to be exported. I brought Power BI and replaced Tableau in my client account in my company. Power BI is far better than Tableau for million reasons except this limitation. Tableau has no limitation on row export. Please work through it and devise a solution ASAP.
RE: Increase Export Data Limits
Any updates on the progress with this?
RE: Increase Export Data Limits
Concur. FIX this... match the row limit of excel.