Overwriting incremental refresh

[smpa01]

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.

@GilbertQ @bcdobbs @AlexisOlson 

does this ensure full refresh of sales beyond baked-in IR policy?

[GilbertQ]

Hi @smpa01 

I would suggest doing a process full on the entire database. This will make sure that all other tables also get all the latest data (there could be other tables which might be missing some data)

[smpa01]

@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.

[bcdobbs · Accepted solution]

Yes a full refresh ignores the refresh policy. You have to pass a use refresh policy parameter if you want to respect it.

[smpa01]

@bcdobbs I can confirm it works.  Now, I have done it, I am currently worrying whther it would still reinstate the incremental refresh policy. 😂

I want he business to be usual (IR as usual) unless I decide to perfrom a FR and once a FR is done does it go back to IR?

Also, what do you mean by You have to pass a use refresh policy parameter if you want to respect it.