Forum Discussion
Solved
Why does Incremental Refresh require DateTime when data contains only date?
Power BI best practices recommend separating DateTime into Date and Time columns to reduce cardinality and improve performance. However, when configuring Incremental Refresh, it forces you to use a ...
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 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