Forum Discussion
Incremental Refresh - Detect Data Change Issues
Hi Anonymous
Here is my test of incremental refresh by connecting to a SQL server data source.
After my testing, if you set parameters on the LastModifiedDate Column, the following happens:
Here is the test procedure that I used to get the result:
1. Create the original data table.
2. Connect to SQL server on Power Bi and get the table. And set parameters on the CreatedDate column.
3. Configuration for incremental refresh
After the configuration on the desktop was completed, I published the report to the service.
4. After the first refresh
5. Updates were made and new data inserted
6. The result
Is this the result you expect?
About more information of configuring incremental refresh:
Best Regards,
Community Support Team _Yuliax
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
No. Given your example I need to turn on the Detect Data Changes button and have that set to the Last Modified Date column. That way ID 123 would have been updated to reflect the Last Modified Data column being updated from 1/1/24 -> 1/9/24. This is the crux of the issue I am running into.