Can I use incremental refresh with a harden date?

[Don-Bot]

I am setting up a new datamodel that will need to be an incremental refresh.  It does have an update date time and a create date time that I can use for incremental refresh.  Where i can grab the records created in the last 60 days and only update the data where the update date time has changed.

However, we also have Harden Dates.  So basically if the Harden Date is filled in then I can simply ignore that record after that date.  Since it will never change again.  

I've searched and can't seem to find where someone has incorporated that with power bi.  is this something I can do?  This could reduce my update dataset by a large amount.  

Any insight would be greatly appreciated.

Thanks

[Anonymous]

Hi @Don-Bot ,

Based on the information you provided, what do you mean by HARDEN DATE? Are you trying to achieve the effect that no records will change after the garden date?

What you need to realize is that an incremental refresh will only add the newly added data and will not change the original data.I recommend you to read the following article:

Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn

^{Best Regards,}

^{Ada Wang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}