Increase Export Data Limits
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.
AdminAdam Wilson (POWER BI)
(Product Manager, Microsoft Power BI)
shared this idea
Thanks everyone for your feedback. We’ve started to explore various options to increase this limit. Stay tuned for updates.
80 comments
-
Anonymous
commented
It is crucial that also custom visuals can handle over 30 000 rows.
-
Peter
commented
Export to CSV should have no limits on number of records being exported.
Unless there is some commercial reasoning behind, for a 21st century app this is a very strange limitation ... -
Tim
commented
There is no benefit to exporting only partial data...increasing the limit is a must!
-
Jaap Olsthoorn
commented
I would still love to see this increased. One of our clients favourite things is asking for a report that shows all transactions of a particular type including all of its metadata. I now create an index on my rows and only display the first 150k, then you can use a slicer to go to the second 150k. It just results in multiple CSV's that you have to append. So it's not even preventing the end users from exporting that many rows, it's just preventing us from doing it conveniently.
I do believe this issue is more common among agencies that work with other clients data, than it would be when powerBI is used as an internal tool (because the internal people could get access to the database directly)
-
Steven Enk
commented
When doing heavy data analysis, it is a definite challenge to tell our users that they can only export so few records. At least getting it to something near to the limit of Excel would be helpful for excel. For CSV, it should be even larger.
-
Lawrence
commented
I'm surprised we're still waiting for this a year later... considering that this idea was originally shared by a Microsoft Power BI Product Manager.
150,000 rows is extremely limiting.
-
ja
commented
I'm run into exporting limit problems too in the past. It would be helpful to have more capability.
-
William
commented
Could you increase the limit to one million rows? We have data sets with over 30 million rows but wouldn't want someone to extract that much data (not to mention that excel only supports up to 1.48~ million rows).
-
Mohamad Kassab
commented
Exporting unlimited number of rows, would be great to have. Data size is getting bigger and bigger everyday, hence, this is essential for business intelligence.
-
Adam Kruzel
commented
Definitely need to increase the export size in Power BI Desktop. I often export to excel to check against other sources and 30k rows limits how much I'm able to check.
-
Michael Buckley
commented
I agree, there should be no export limits. Who wants to export partial data?!
-
Jagruthi
commented
PBI team any update on this. Can we expect in this near future
-
Anonymous
commented
Why limit the export at all? Since we are merely dumping the table into a csv file, I can see no reason why the entire table (of any size) cannot be dumped to the csv. We often use PBI Desktop to mashup the data, then need to post-process it in some other software. Is there any legitimate reason why MS needs to limit the number of rows? If PBI can create a table with millions of rows, we certainly should be able to dump the full table to a csv.
-
Tamsin Harriman
commented
I agree with other comments - this should be unlimited if at all possible, for live/direct query as well as other types of connection.
-
sharathp
commented
does it export 150,000 rows when using Direct Query? I'm trying to export around 40K rows but it only exports 20K+ rows and each time i export i get a different number.
-
Sherry
commented
I need to export more rows. There should not be a limit!
-
JAVIER SIERRA
commented
Why limits? I don't understand it.
-
Anonymous
commented
no limits
-
Anonymous
commented
Yes
-
Michael Camiolo
commented
Enable the summarized report to be exported to Excel.