I have a dataflow that i used to extract data from business central. i want to apply incremental refresh on the dataflow, i setup the refresh with the following settings :
column to filter by:
PostingDate
extract data from the past 1 week
bucket size:
day
only extract data when the maximum value in this column changes :
LastModifiedDateTime.
the user updated records from Jan 2025, but the records didnt update in my dataflow.
can anyone give me guidance on how i should setup my dataflow's incremental refresh so it updates whenever any record changes?