Forum Discussion

smpa01's avatar
smpa01
Community Champion
2 years ago
Solved

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 pol...
Need Help
  • bcdobbs's avatar
    bcdobbs
    2 years ago

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

smpa01's avatar
smpa01
Community Champion
2 years ago

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's avatar
bcdobbs
Community Champion
2 years ago

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

  • smpa01's avatar
    smpa01
    Community Champion
    2 years ago

    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.