Solved: Incremental Refresh on Current Data

Jaf017 · ‎01-31-2019

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 · ‎01-31-2019

@Jaf017,

Refresh operations in the service run under UTC time.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎01-31-2019

@Jaf017,

Refresh operations in the service run under UTC time.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.