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
Thanks for your responses
My question is at one side Power bi suggest separate date and time in individual column as best practice while other hand for increamental refesh it forces you to use a column with DateTime data type even if your dataset only contains dates and no time component.
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 checking in on your earlier response posted by lbendlin regarding the incremental refresh setup. Were you able to try out the approach earlier shared with the M code and is the issue resolved ?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?
