Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
1 day ago

Incremental Refresh Decision

I am creating fresh (new) semantic model, I am not sure whether I should implement incremental refresh now or later point of time . I do not want to change or overwrite semantic model once it move to...
Need Help
power bi
krishnakanth240's avatar
krishnakanth240
Icon for Super User rankSuper User
1 day ago

Hi powerbiexpert22​ 

Since it is a new semantic model, I would recommend deciding the incremental-refresh one before production. If the fact table is large and growing and if the source supports query folding then configuring incremental refresh in Dev or Test and validating the refresh and then deploying the tested model to Production.

Can you confirm these

What is the current and expected data volume/row count

How much historical data needs to be retained 

How frequently is the data refreshed

What is the source system

Is query folding supported for the date/time filter

Is the data append-only or can historical records be updated/deleted