Incremental Refresh on Current Data

[Jaf017]

I have a data source in Power BI that is an aggregation for a set of variables. It refreshes every morning at 6 AM and then refreshes over itself upon each refresh.

Therefore I tried incremental refresh to store my data to track the aggregation over time. However, when I'm setting up the parameters for the incremental refresh it only lets me refresh the rows from yesterday, which overwrites my data with today's.

Is there a way around the 1 day minimum? I'd like to ONLY refresh rows for today.

[v-chuncz-msft · Accepted solution]

@Jaf017,

Refresh operations in the service run under UTC time.

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh