Forum Discussion

Melec's avatar
Melec
Frequent Visitor
2 years ago

Incremental refresh overlap

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

Dataflow
Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

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

     

    Are you located in a timezone that is matching UTC?

    • Melec's avatar
      Melec
      Frequent Visitor
      2 years ago

      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's avatar
        lbendlin
        Super User
        2 years ago

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