Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Export Data Limit to Increase to 100,000

Provide the ability to increase the Export Data limit to 100,000 records
Status: Completed
Comments
nishalit
New Member
In late 2016, we 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. You can read more in the documentation below: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-export-data/#limitations-and-considerations Many of the votes and comments on this idea were from before we increased these limits. We would like to hear from the community again about whether the new limits are sufficient, or whether more data is required. We are closing this idea, but if you still need higher limits please let us know by voting on the idea below: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18432742-increase-export-data-limits
emilycs
New Member
Would also like a way to see how many rows are exporting (so we know if we're over limit)
jlumpkin
New Member
It would also useful to be able to export from PBI Desktop as well as from the Service.
fbcideas_migusr
New Member
Please increase the limit to beyond 10000, which is too small.
hardikabhavsar
New Member
do you guys have any plan to increase the limit to beyond 10000 anytime soon?
gregory_dumont-
New Member
Now I see that it's 30000, and it's still too small. I would like to be able to choose the export limit for each report (or at least data source).
mattgross
New Member
I also need the export data limit increased above the current 30k limit. 100k records would be ideal.
fbcideas_migusr
New Member
bump... 30k is far too small. I was pretty surprised. Is there any chance we can have an explanation as to any limit < 1M? a CSV is a simple txt file so I have a hard time understanding what drives the limit?
mircea1
New Member
This is a must be feature!
nicola_jelmori1
New Member
In the data model, you could do a copy of an entire table, but if the table is too big this is not possible. All in all, with Power BI Desktop it is possible to import a lot of data, but then you can’t export them.