Suggested by Ashish Elthuri – Completed
Following the doc (https://learn.microsoft.com/en-us/industry/sustainability/sustainability-manager-import-data-incremental-refresh) for setting up incremental refresh.
Used Transaction date to filter the source data and kept Store rows from the past = 2 days and Refresh rows from the past = 1 day.
Issue – With above configurations, data is being updated from past 2 days.
As Refresh rows from the past = 1 days, it should take past 1 day data for the updates.
Please suggest.