Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
What is your reasoning for choosing the "only complete days" option?
Are you located in a timezone that is matching UTC?
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.
Not sure what else to suggest. Maybe raise a support ticket. Or live with the blip.
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 !
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.