Update time different in gateway for On Demand and Scheduled

[joshua1990]

Hello together!

I have successfully transferred the incremental refresh for a transactional table (SQL Server).
But there are two challenges:
The refresh time is very different between "On Demand" and "Scheduled" refresh, as you can see here:

These are just the last two refreshes.

I have of course used RangeStart and RangeEnd as parameters. Unfortunately, these are not recognized in the PBI service:

What is the reason for this and why does the refresh still work?

[v-xulin-mstf]

Hi @joshua1990,

The report do not have incremental refresh applied, because the parameters have not been defined for the datasets.

Please refer this about how to configure incremental refresh: https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh

Best Regards,

Link