Forum Discussion
Export to CSV from service results in Incomplete rows
when you say it failes to export but i dont fully undertand what the issue you are experiencing, does it not export at all? do you get an error message? could it be that it was disabled in the dashboard options?
or have these settings been set at the tenant level by the admin to disable export?
- briguy4414 years agoRegular Visitor
I have the same problem. Seems like there is some sort of download limit, around a file size of ~500k. I am trying to export 61 columns of data, with 6800 rows, from a table visual, using the "Data with Current Layout" option, into a xlsx file, from an power BI app on the web. I can not get all the data in one download. I only get about 2600 rows when I download, all 61 columns. I noticed that if I reduce the number of columns, I get more rows. However, the size of the file seem to max out around 500k.
- Rishabh-Maini4 years ago
Helper II
Hi vanessafvg,
Thank you for your reply.
When I say it fails to export, I mean that only a limited number of rows are exported.
My PowerBI table has, for example, 4k rows. The .csv file that gets exported contains only about 1.8k rows.
The options in the images you provided are already enabled in my Desktop and Service.
Also, the number of rows are always less than the 30k limit of a .csv export. I can't really understand why.