For a data source to be able to support incremental updates, it needs to be a structured, relational database and it needs:
- a primary key column that uniquely identifies records
- a date/time column that indicates when the data was last updated
In Customer Insights – Data this is now:
- Some sources in Power Query like (not a complete list)
- Azure SQL Database
- SQL Database
- SAP…
Continue Reading Malin Martnes’s Article on their blog
MB-260: Identify data sources that support incremental updates
This post identifies data sources that support incremental updates
Blog Syndicated with Malin Martnes’s Permission