Forum Discussion
Export error: "Your data is too large. Some data sampling may occur."
This is a known issue, please vote the idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9609906-export-powerbi-desktop-to-csv-excel
I suggest you directly import the source data into the Excel/CSV file. For example, if it's from SQL table, you can copy the query result set into Excel worksheet.
Regards,
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 than 60k of lines.