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
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.