Incremental Refresh Missing Data

Hi All,

I have an incremental refresh on a dataflow that pulls in new information daily (e.g. Refresh rows from the past 1 day) from an ODBC connection.

My issue is over the weekend one day of my incremental refresh only pulled 2 rows, which is incredibly outside the norm:

The refresh history says it was completed but it took 2x longer than usual:

Since this refresh, the rest of the incremental refreshes have been fine and have the expected amount of data, it's just this day that didn't run as expected.

When I run the query in the database and when I am making my dataflow to add in this missing date the query runs with many more than 2 rows so I don't understand how this happened or, more importantly, how to stop it happening again the future.

Does anyone have any insight?

Thanks