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.
As I mentioned in my earlier reply you can do the conversion/casting as part of the filter step in Power Query,