Forum Discussion

Priti_Gaikwad's avatar
Priti_Gaikwad
Helper II
1 year ago
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 ...
  • lbendlin's avatar
    lbendlin
    1 year ago

    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