Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Melec
Frequent Visitor

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.

incremental_small.PNGactualisation.PNG

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

duplicated_request.PNG

Next refresh

next_request.PNG

 

 

 

Has anyone experienced this kind of behaviour ?

 

Regards,

Melec

4 REPLIES 4
lbendlin
Super User
Super User

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 !

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors