Incremental refresh overlap

[Melec]

Hello,

I have created a Power BI Dataflow which request data from BigQuery with incremental refresh but it does not work exactly like I want.

I chose to refresh the data everyday at 4 AM using only complete days.

However the refresh always makes two requests. One for the previous day and another one for the day before which is clearly not intended. Surprisingly, every additional refresh (manual or scheduled) work fine and request only the previous day.

First refresh

Next refresh

Has anyone experienced this kind of behaviour ?

Regards,

Melec

[lbendlin]

What is your reasoning for choosing the "only complete days"  option?

Are you located in a timezone that is matching UTC?

[Melec]

Hi,

I chose this option because the actualization occurs at 4 am UTC. Otherwise, every refresh would request the previous day plus the current day which would not be complete.

All my timestamps are localized with UTC timezone.

Thanks for your help.

[lbendlin]

Not sure what else to suggest. Maybe raise a support ticket.  Or live with the blip.

[Melec]

We could let the incremental refresh as it is, the dataflow is updated anyway. But the additional request double the cost and I would really like to avoid it.
I will ask the support about it.

Thanks for your help !