Forum Discussion
Dataset isnt uploading : bug or wait ?
- 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."
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."
Hello lbendlin , thanks for your answer !
I don't know if there is a correlation but i try to send the file to my client to try to open it and publish it directly from his power bi Desktop. He has an error message saying : "File name" is damaged and cannot be open by Power BI Desktop. Is this issue correlated to the fact that i cant publish it ?
- lbendlin1 year agoSuper User
how do you send that file to you client? it's likely too big for email