Hello we have a dataset whereby the rows contained a datetime field.But because of the high cardinality we splitted this in a date and a time field.We have to refresh this data on a daily basis. But for that we need a datetime field.But then we create again the isssue of the high cardinality.In the table we also have a day-key. Do you always need a datetime field to do a refresh?How to solve this problem? RegardsRon

Yes. That was your goal, to keep the cardinality low, right?

Incremental refresh using datetime | Microsoft Fabric Community

lbendlin
Super User
4 years ago
Your RangeStart and RangeEnd parameters need to be DateTime, and they need to be used in the Power Query filter for the query/table that you want to implement incremental refresh for.

But it doesn't really matter what they compare to. So you could write a filter that says

DateValue+TimeValue > RangeStart and DateValue+TimeValue <= RangeEnd
- PowerRon
  Post Patron
  4 years ago
  Ok, so you then keep the date and time field as separate fields? Also when comparing to RangeStart and RangeEnd>
  - lbendlin
    Super User
    4 years ago
    Yes. That was your goal, to keep the cardinality low, right?
PowerRon
Post Patron
4 years ago
lbendlin one more question. It is not possible to use just a Date field (so not a Datetime field) for RangeStart and RangeEnd?

regards
Ron
- lbendlin
  Super User
  4 years ago
  Sure. All you need is to cast your date field as datetime during the comparison (basically pegging the time at midnight)
  - PowerRon
    Post Patron
    4 years ago
    Hmm, how does the casting work lbendlin ?
    Not yet so experienced in Power Query and refresh
PowerRon
Post Patron
4 years ago
Hmm, how does the casting work lbendlin ?
Not yet so experienced in Power Query and refresh