Power BI External Incremental Refresh Option

[Michaeldias]

Hello all,

I'm setting up incremental refresh for the first time and need some advice.

Having read the online documentation I can't see my use-case.

We've enabled incremental refreshes as the original data is from an external vendor that we do not have good access to.

This incrementally refreshes about 1 million records of the last 3 months of data on an hourly basis. On weekends it does a full refresh of 20million records.

In Power BI I'd like to incrementally refresh the last 3 months of data but also target everything on the weekend.

Ideally this would not require changing parameters or settings within Power BI.

Any pointers?

[v-zhangti]

Hi, @Michaeldias 

After applying incremental refresh, only data for the period specified in the refresh policy setting is refreshed. In this case, to refresh all the data again, you need to turn off incremental refresh, manual refresh, or scheduled refresh. Then, to refresh incrementally again, you need to reconfigure and publish.

For reference:

Configure incremental refresh and real-time data for Power BI datasets - Power BI | Microsoft Learn

Full refresh + Incremental refresh of dataflows - Microsoft Power BI Community

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Michaeldias]

Thank you for this.
I know this is an option but I wanted to leave incremental refresh on permanently.

For example if the date column is an updated date I was thinking it would capture external incremental changes only and on the weekend it would see everything as the date would have changed.