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 th...
Need Help
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!

  • cobwebz's avatar
    cobwebz
    Frequent Visitor
    8 years ago

    Any other ideas on this? Thanks!

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      8 years ago
      Could you not connect directly to the SQL Server Source?

      And it would appear that because you are using DirectQuery that is a current limitation. If the data model was imported you would be able to extract with the standard options.