Forum Discussion
Export error: "Your data is too large. Some data sampling may occur."
- 10 years ago
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,
Since the last update... you can now export up to 30K rows. Still too low as other I would just use Access.
- leinad139 years agoAdvocate I
It's a bit of joke this 'issue' as its not an issue at all - its a limit, implemented intentionally by microsoft in order to try and get you to export your data to their cloud! Why don't Microsoft put a note near the PBI Desktop download saying that there are limits on data export. No-one expects to be limited what data you can export, other than by your own hardware.
- sz4C10 years agoAdvocate I
I agree. 30K is still too low. Since there are a little over 40,000 zip codes in the US, this limitation means that you won't be able to export data that has been aggregated at the zip code level (which MANY business people do).
- sz4C10 years agoAdvocate I
I agree. 30K is too low. Since there are a little over 40,000 zip codes in the US, this limitation means that you can't export data that has been aggregated at the zip code level (which MANY business people do). This is a severe limitation in my book.