Hi,
I am trying to implement Incremental refresh and a bit confused about how I can use "Detect data changes". I have a fact table with a Datekey column (the date of the transaction), in addition to a UpdatedDate column (when the row is last updated). I have set the RangeEnd and RangeStart filters on Datekey, and using UpdatedDate for the "Detect data changes" option.
When testing this I noticed when I updated a row in the Archived data (more than 1 month), and set the UpdatedDate to the current date that is inside the Incremental Refresh period, it is not fetched and refreshed. I consider two things from this:
1. Set the incremental refresh period as long as the archived period to always fetch and refresh updated rows.
2. Change the RangeStart and RangeEnd filters to UpdatedDate instead of Datekey and don't use "Detect data changes"
Helpful resources
Power BI Dataviz World Championships
Vote for your favorite vizzies from the Power BI World Championship submissions!
Join our Community Sticker Challenge 2026
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Power BI Monthly Update - January 2026
Check out the January 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
| User | Count |
|---|---|
| 55 | |
| 52 | |
| 41 | |
| 16 | |
| 16 |
