Forum Discussion

YacinO's avatar
YacinO
Regular Visitor
1 year ago
Solved

Dataset isnt uploading : bug or wait ?

Hello everyone, thanks for reading me !    Im uploading on an external tenant a 9.6 Go dataset. Few days before i already upload a 12Go dataset and everything went well. But today when I try to up...
  • lbendlin's avatar
    1 year ago

    There is a 10GB limit per partition.  Most likely your 12 GB semantic model was compressed to fall under the limit, or your partitions were smaller.

     

    The standard approach for the initial load of overly large semantic models is partition bootstrapping.

    "For very large models in Premium capacities that likely contain billions of rows, the initial refresh operation can be bootstrapped. Bootstrapping allows the service to create table and partition objects for the model, but doesn't load and process data into any of the partitions. By using SQL Server Management Studio, you can set partitions to be processed individually, sequentially, or in parallel, to both reduce the amount of data returned in a single query, and also bypass the five-hour time limit. To learn more, see Advanced incremental refresh - Prevent timeouts on initial full refresh."