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
lbendlin Will check this solution & update u
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.