Forum Discussion
Help needed: Detect Data Changes on Modified column with Incremental Refresh
Hi, I’ve configured incremental refresh on a Power BI dataset. The source is SQL views, and the underlying tables contain both Created and Modified date columns. In Power Query, I applied the...
Hi automation,
When using Detect Data Changes, only the incremental refresh period is eligible for refresh. Rows outside this period will not be reprocessed even if their change detection column is updated.
Partition the dataset using ModifiedDate (rather than CreatedDate) so that updated records fall within the incremental range and are reprocessed automatically.
Use ModifiedDate as the column defining RangeStart and RangeEnd. This is the only configuration that reliably captures updates to older data.