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
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.lbendlin v-aatheeque
Thanks for following up. Above solution worked for me
As I mentioned in my earlier reply you can do the conversion/casting as part of the filter step in Power Query,
