Hi uzuntasgokberk ,
Please ensure that the M query for your table includes a filter based on RangeStart and RangeEnd. The column returned by the polling query, such as MaxREFRESH_BOOKMARK, should indicate when the latest data is refreshed. If there's a retro change to the data, the MaxREFRESH_BOOKMARK should differ from the last processed time.
Select Detect data changes to specify a date/time column used to identify and refresh only the days where the data has changed. A date/time column must exist, usually for auditing purposes, at the data source. This column should not be the same column used to partition the data with the RangeStart and RangeEnd parameters. The maximum value of this column is evaluated for each of the periods in the incremental range.
If you need to capture update made to data created/inserted in the year 2022, the incremental refresh policy needs to refresh past 3 years data.
Best regards.
Community Support Team_Caitlyn