Forum Discussion
Overwriting incremental refresh
I have inherited a dataset (semantic model) which has incremental refresh baked in. Hence, it is not downloadbale and I don't have access to the local pbix.
One of the tables have a refresh policy as 7 days and the data source it relied upon went rougue. I have fixed the dataset and I want to run a full refresh on that table for all partitions so that all up-2-date data get ingested in all the partitions (currently the partitions contain rogue and stale data) and then go back to the exisitng refresh policy (7 days).
I have access to SSMS and Tabular Editor 2.19.
does this ensure full refresh of sales beyond baked-in IR policy?
Yes a full refresh ignores the refresh policy. You have to pass a use refresh policy parameter if you want to respect it.
4 Replies
GilbertQ thanks !!! my Q is does "process full" of the entire database ensure ingesting data to the sales table ( as well as to the other tables) despite currently having a incremental refresh policy of 7 days? My worry is whether the one time "process full" is still subject to existing 7 days IR policy. In that case, even doing process full will only correctly ingest last 7days and not prior to that.
Yes a full refresh ignores the refresh policy. You have to pass a use refresh policy parameter if you want to respect it.
