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
hello Priti_Gaikwad
as far as my knowledge, incremental refresh does refresh partial of your data depend on range of date.
with incremental refresh, you need to set from when to when the refresh will be done.
Other than that, the data will not be refreshed.
the performance increase from incremental refresh comes from reducing the data needed to be refreshed.
Thank you.