Forum Discussion
refresh , data volume and incremental refresh
1. what is meaning of background refresh in terms of power bi? is it report refresh?
2. can we configure to use specific amount of capacity for background refresh?
3. can semantic model handle more than 100GB data in case of F64 fabric capacity?
4. is there a way to setup incremental refresh based on id or any other parameter other than dates?
powerbiexpert22 , I want to amend my answer for #2 and provide some additional info that I just learned thanks to your question. There is no way to set a specific amount of capacity for model refresh, however there is a way to limit the max memory used by semantic models in a capacity. Here is more information on that feature: https://learn.microsoft.com/en-us/fabric/enterprise/powerbi/service-admin-premium-workloads#power-bi-settings
6 Replies
- djurecicSuper User
Hi powerbiexpert22 ,
1. Not exactly sure what you are referrring to, but it could be this: https://learn.microsoft.com/en-us/power-bi/guidance/power-query-background-refresh
Or could mean the refresh of the semantic model (report data)
2. No, I'm pretty sure there is not.
3. The max model size is 25GB for F64. This is not the same as 25 GB source data size, since the data is compressed (assuming you are using import mode)
4. Incremental refresh requires a RangeStart and RangeEnd date. https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
- powerbiexpert22Impactful Individual
Hi cengizhanarslan , djurecic ,
is there any proof of not reserving capacity for back ground refresh from microsoft official documentation?
- djurecicSuper User
powerbiexpert22 , I want to amend my answer for #2 and provide some additional info that I just learned thanks to your question. There is no way to set a specific amount of capacity for model refresh, however there is a way to limit the max memory used by semantic models in a capacity. Here is more information on that feature: https://learn.microsoft.com/en-us/fabric/enterprise/powerbi/service-admin-premium-workloads#power-bi-settings
- v-sgandrathiCommunity Support
Hi powerbiexpert22,
Thank you djurecic and cengizhanarslan for your reesponse to the query.
I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.
Thank you. - v-sgandrathiCommunity Support
Hi powerbiexpert22,
Just checking in! We noticed you haven’t responded yet, and we want to make sure your question gets fully resolved.
Let us know if you need any additional support.
Thanks again for contributing to the Microsoft Fabric Community!