I am getting confused on incremental refresh. Suppose my date column is nothing but month_start_date in this format. As you see in below snapshots there are multiple month_start_date so if I setup my incremental refresh based on month_start_date with window size 90 and Unit =Day. What month_start_date will it pick the latest one or just random. Because it takes nearly 2+hours in incremental refresh and 3+ hours for full refresh and it has become cumbersome on getting what rows having what dates have been replaced. I want it to take the latest month_start_date (as of today it would be Nov 1, 2025) from dataset and perfrom incremental refresh of last 90 days
It should take everything that is less than 90 days in the past.
So if you refresh on 2025-11-04, it will include all dates that are after 2025-08-06 (in your case 1st of Sep and 1st of Oct). But the reference date is always at the time of refresh, so if you want to include 1st of August, you’ll have to use window size of 120 days
@atulrana have a look at this post where I have given an example of what the window size means ( Scheduled incremental refresh of dataset is not working - #3 by Koushik_Muthanna )