Forum Discussion

cobwebz's avatar
cobwebz
Frequent Visitor
8 years ago

Data Export Truncating Despite Being Well Below Posted Size Limits

Good morning...

 

For starters, I understand that when exporting underlying data on the Service the row limit is 150k, and the file size limit when using DirectQuery is 16MB. When I do an export the resulting file only has about 10,900 rows, and the XLSX file size is only 5.13MB. We have 12 months worth of data, and it is cutting off the last 2 1/2 months or so. When I run an export on only those few months the resulting file has just over 11,000 rows, and the size is 5.4MB. Even stitched together, the resulting file would still be under the 16MB limit. Am I missing something here? Why does it cut off around 5MB instead of 16MB? Thanks!

Need Help

4 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi cobwebz,

     

    What is your data source type? Are rows cut off if you choose to export data to .csv?

     

    Regards,

    Yuliana Gu

    • cobwebz's avatar
      cobwebz
      Frequent Visitor
      8 years ago

      Good morning! There isn't an option to export unerlying data to a CSV, as I get the following message: "At this time, we only support exporting underlying data to Excel format (.xlsx)." As for the data source type, it is SQL Server using the DirectQuery connectivity mode. Thanks!