incremental refresh policy

Hi prasadpatil020 

If order status changes for records where updated date is not refreshed correctly or falls outside that window like late updates, backdated changes or incorrect timestamps then those changes will not be picked up leading to incorrect status in the report.

When you extend it to 3 months then more partitions are refreshed, so those missed updates get corrected which is why it appears to work.

Likely causes are updated date column is not changing on every status update, source system updates old records without updating the timestamp, data delayed updates beyond 2 days

Ensure updated date is a true last modified column or increase the refresh window like 7 to 30 days to capture late changes