Forum Discussion
pstanek
Post Patron
Post PatronExport table
Hi Is it possiple to export table into csv with more than 30 000 rows? Is it possible to export Matrix into csv ( or another format) with Matrix format?When I export matrix to csv, it will have ...
v-caliao-msft
Microsoft Employee
Microsoft EmployeeHi Pstanek,
For the first question, you may encounter the issue "Your data is too large. Some data sampling may occur." when export 30 000 rows from Power BI to desktop. Here is a similar issue, please refer to the link below to see the details.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9609906-export-powerbi-desktop-to-csv-excel
For the second issue, as kcantor said, we cannot keep the matrix format when exporting to CSV. Since the format won't be keeped, in your scenario, you can export your data directly from your database to avoid the first issue.
Regards,
Charlie Liao