Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
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)
@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 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.