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
Helpful resources
Power BI Monthly Update - April 2026
Check out the April 2026 Power BI update to learn about new features.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
FabCon &SQLCon Highlights
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
