Forum Discussion
Why does Incremental Refresh require DateTime when data contains only date?
The best practice recommendation is valid for incremental refresh setups as well, guaranteeing that all time values inside a date will sit in the same partition. You can do the conversion at the last minute, via
let d = Datetime.From([Date value]) in d >= RangeStart and d < RangeEnd
Hi Priti_Gaikwad
Just following up to see if you had a chance to try out the suggested solution by lbendlin with the Datetime. From conversion. Did it help resolve the issue on your side ?
What I did is with DateTime.From coversion I created custom column with my original Date column and then I set RangeStart & RangeEnd date filter on that custom column and Finally I hide that column in model and applied Incremental refresh
Please tell me whether this approach is correct?
You can do that as well but it will require (some) additional storage for that column. If it works for your scenario then go for it.
lbendlin Please tell me if have any altrenate to this which could save the storage.
Hi Priti_Gaikwad
We haven’t heard from you on the last response posted by lbendlin and was just checking back to see if your query got answered. Otherwise, will respond back with the more details and we will try to help.