Incremental refresh saving deleted records in data source

Hi Syndicate_Admin ,

According to your statement, I think you want to load data in two-day period into your data model instead of one-day period.

I think you can set "Incrementally refresh data starting before refresh date" as you want in Incrementally refresh setting.

For example, if we specify a refresh period of 3 days, with each refresh operation the service overrides the RangeStart and RangeEnd parameters to create a query for rows with a date/time within a three-day period, beginning and ending dependent on the current date and time. Rows with a date/time in the last 3 days up to the current refresh operation time are refreshed. 

For reference:

Incremental refresh and real-time data for datasets

Best Regards,
Rico Zhou

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