Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-21-2026 08:06 AM
Hello Kevin !
It happened with me once and that's how I understood that for auto cdc the delta source needs a change feed.
When it is not available you should use AUTO CDC FROM SNAPSHOT which compares snapshots and with do the synth of the changes instead.
And that also explains why you will have a failure when the source is updated with INSERT OVERWRITE and CDF is off.
If this answer resolves your question, could you please mark it as “Accept as Solution”? It will help other users quickly find the correct fix.
Senior BI/Data Engineer | Microsoft MVP Data Platform | Microsoft MVP Power BI | Power BI Super User | C# Corner MVP
Senior BI/Data Engineer | Microsoft MVP Data Platform | Microsoft MVP Power BI | Power BI Super User | C# Corner MVP
