powerbi - What is the WHERE clause in incremental refresh when the schedule refresh is configured to run at 12AM?

Question

I have dataset with incremental refresh configured, so as to refresh last 1 day of data. The filter is set as - is after or equal to RangeStart And is before RangeEnd.

The refresh schedule is set for 8am, 8pm.

When the refresh runs at 8am (say today is 4th Jan 2021), the query fired on the SQL server has the condition as date>=20210104 00:00 and date<20210104 08:00.

Similarly when run at 8pm the query is date>=20210104 00:00 and date<20210104 20:00.

Suppose the schedule is set at 12AM. Then what will be the underlying WHERE clause? Is 12AM considered as the current day (date>=20210104 00:00 and date<20210105 00:00) or the next day (date>=20210105 00:00 and date<20210105 00:00)? Is there any documentation on this?

question from:https://stackoverflow.com/questions/65560241/what-is-the-where-clause-in-incremental-refresh-when-the-schedule-refresh-is-con

Answer 1

Waitting for answers