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
Just checking in on your earlier question regarding the use of Datetime columns for Incremental Refresh in Power BI.
lbendlin Irwan provided guidance explaining why Datetime is currently required (even for date-only data) and how appending a midnight timestamp is a valid workaround to balance cardinality and refresh behavior.
Could you please confirm if the provided solution helped in your scenario?
Let us know if you're still facing any blockers we're happy to assist further if needed!
just circling back on your earlier question about using Datetime columns for Incremental Refresh in Power BI.
lbendlin Irwan had explained why a full Datetime column is required even when working with date-only data and suggested appending a midnight timestamp as a practical workaround to maintain refresh compatibility while keeping cardinality low.
Could you let us know if this approach worked for you?
If you're still running into any challenges, we're here to help!