Forum Discussion
prasadpatil020
Helper I
4 months agoincremental refresh policy
Hi Community..!! I am using incremental refresh in the power bi , 1 year data and incremental refresh on 2 days on updated date, we have kept refresh twice a day in power bi workspace, but report is...
Lodha_Jaydeep
Solution Sage
4 months agoHi prasadpatil020,
Thanks for reaching fabric community will happy to assist.
This usually comes down to how incremental refresh behaves with the Updated Date column.
With a 2-day window, Power BI only refreshes records where the updated date falls in the last 2 days. So:
- If an order was updated yesterday → it gets picked up
- If it was updated 3 days ago → it gets missed (As same as you mentioned)
That’s why things look correct when you use a larger window (like 3 months), but not with 2 days.
- You can try increasing the refresh window to around 7-14 days may give you accurate result
For more you can go throgh the documentations below.
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure