Forum Discussion
Solved
Incremental refresh using datetime
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 bas...
Yes. That was your goal, to keep the cardinality low, right?
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
