Export to CSV from service results in Incomplete rows

[Rishabh-Maini]

Hi,

I have a table visual that I'd like to export into a CSV. Although, it never exports all the records in the visual. I've enabled both options: "Don't summarize" and "Show items with no data" for all the columns as well, but still haven't gotten it to work. 

I tried exporting the other tables in my report as well, they all fail to export all the records. Is this a PowerBI issue?

Any suggestions, what I might be doing wrong?

[AdrianLawrence]

I've the same issue, my report has 15000 rows but it does not match the underlying data, its an issue as we want to use the report to help us reconcile our accounting records, which of course we can't do if its not an exact match

[Anonymous]

Hi, 

I am hitting the same roadblock is there any solutions to that? 
I have only 4788 rows to export but when I am exporting from Service only 5438 are getting exported. 
I checked each rows that wasn't pulled from the dataset and the data looks clean. 

I also checked to pull the data directly from the data tab in powerbi service and that works as expected. 

Any idea how to fix this?

[Anonymous]

Hi  @Rishabh-Maini ,

You can open a support ticket.

This is the website of create support ticket:

https://powerbi.microsoft.com/en-us/support/

How to create a support ticket in Power BI :

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi  @Rishabh-Maini ,

There are some limitations when exporting data from a visual, you can refer to this article: 

• When using DirectQuery, the maximum amount of data that can be exported is 16 MB. This may result in exporting less than the maximum number of rows, especially if there are many columns, data that is difficult to compress, and other factors that increase file size and decrease number of rows exported.
• If the visual uses data from more than one data table, and no relationship exists for those tables in the data model, only data for the first table is exported.

You can check if there are the above restrictions in your scene.

You can also check whether the number of rows in your table visual object is the same as the number of rows in your PBIX, when some of your data is repeated, it will be automatically aggregated into a row in the table visual object, so that there will be missing data. If this is the case, you can add an Index column for each row through Power query, so that the exported data is complete.

This is the related document, you can view this content:

https://community.powerbi.com/t5/Issues/Power-BI-not-exporting-all-rows-from-a-table/idi-p/533983

https://forum.enterprisedna.co/t/table-not-showing-all-records-when-exporting/5934/10

https://community.powerbi.com/t5/Issues/Export-Data-from-Visual-Feature-Providing-Inconsistent-Total...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Rishabh-Maini]

Hi @Anonymous ,

None of those restrictions apply to my visual.  I am trying to export records no more than a total of 2-3 MB.

It's difficult to use PowerQuery/RANKX/COUNTROW to add an index for each row, since it is a visual which consists of columns from different tables. Yes, all those tables have a relationship defined in the model. 

I have a column with unique values, so I am quite sure I wouldn't need to use any other index to check for missing data. 

Random rows disappear in the export table, which I was able to pinpoint as well. ( Using the column with unique values as well as a date-time column).

Feels like I've hit a roadblock here. 

Would you recommend opening a ticket with microsoft?

Thanks,
Rishabh

[Anonymous]

Hi  @Rishabh-Maini ,

The documentation states that there is a limit of rows that can be exportet to csv, this limit is 30000 rows.

Using the target format xlsx this limit is 150k rows, the export to xlsx option is available in Power BI Service.

These limits are described here and a description of the two options "Don't summarize" and "Show items with no data":

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#limitations-and...

You can use DAX Studio external tools to export the data to the entire model:

https://xxlbi.com/blog/dax-studio-export-all-data/

https://daxstudio.org/

This is the related document, you can view this content:

https://stackoverflow.com/questions/51375021/export-data-from-power-bi-to-sql-server-overcome-the-li...

https://community.powerbi.com/t5/Desktop/Exporting-a-table-with-over-1-million-rows/td-p/1160327

https://community.powerbi.com/t5/Desktop/Exporting-a-large-number-of-rows-from-Power-BI-to-Excel-or-...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Rishabh-Maini]

Hi @Anonymous ,

Thank you for your reply.

My table has always less than 30k records. 
I also disbaled the "Show items with no data" option, yet all the records fail to be exported. 

Any other solution that you might know of?

[vanessafvg]

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?

[briguy441]

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-Maini]

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.