We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.