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

View all the Fabric Data Days sessions on demand. View schedule

Export Data Limit to Increase to 100,000

Provide the ability to increase the Export Data limit to 100,000 records
Status: Completed
Comments
lrogers
New Member
Large data requires the ability to export large data sets and 30,000 records is not enough.
inicholls
New Member
Trying to do analysis in MDM of contacts, we have 250k contacts so can't get the data in Excel via PowerBI 😞
Adnan_Alam
New Member
for BOM analysis, must need to have capability to export at least 100K.
dvaughn2
New Member
Please increase export data limit to same as row limit in excel
chris_hawes_gre
New Member
Please consider a 1,000,000 row limit. This is a business necessity.
gregory_dumont-
New Member
100k is a must have, but 1million seems even better.
GTASTEVE
New Member
This workaround will create chunks of 20k lines which can be exported. 1) add an index column to your table called "index" 2) add a new column named "EXPORT_GROUP" to your table (in the example below change TblName to your actual table name) : EXPORT_GROUP = switch (true () , AND(TblName[Index]>=0, TblName[Index]<=20000), "Group1", AND(TblName[Index]>=20001, TblName[Index]<=40000), "Group2", "Group3") you can now create a slicer for the EXPORT_GROUP and export your data in sections. Add more Groups if you have a more thank 60k of lines.
kammaru
Advocate I
Please increase this 30000 limit to 10,00000
Dan2027
Regular Visitor
Please consider a 1,000,000 row limit.
_Emil_
Advocate II
I get 150k rows in Excel and 30k in CSV, unfortunately my data is 165k. Would be nice if there is a warning (in browser) that tells users they cannot export all data, and if they wish to continue.