Forum Discussion
Incremental Refresh not working on Schedule Refresh
Hello community,
I am testing out how incremental refresh works. I noticed that whenever the refreshes happen "on schedule", the refresh time takes a lot longer so I am guessing maybe the incremetal refresh is not working?
When I manually refresh the dataset, it only takes a few seconds rather than a few mintures. I am not too sure if I have the set up wrong somewhere so it's not doing incremental refresh on schedule refresh.
Any insights will be apprecaited, thank you.
2 Replies
Hi lliu_western ,
You should know that:
- Incremental refresh policies are defined in Power BI Desktop and applied when published to the Power BI service.
- The first refresh may take longer to import the historical data. Subsequent refreshes can be much quicker because they use incremental refresh.
- The target of scheduled refresh is to initiate the refresh within 15 minutes of the scheduled time slot, but a delay of up to one hour can occur if the service can't allocate the required resources sooner.
For further information about data refresh, you can refer the following Microsoft documents that could help you:
- https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
- https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh
- https://docs.microsoft.com/en-us/power-bi/refresh-data
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi.
The main problem is that manual refresh use incremental refresh, schedule refresh don't use incremental refresh but full refresh instead. The same thing is happening in my case too. Why?
Borut
