Forum Discussion
Schedule refresh issue
Hi wleecwleec_2
The primary challenge relates to timing. Your Power BI Service dataset relies on an IT-managed model that refreshes at 6 AM, but this process may occasionally complete later than planned. As a result, when your dataset is set to refresh at 7:30 AM, it can begin before the source data is fully updated, leading to instances where the refresh completes without reflecting the latest data. The consistent stability of your 2 PM refresh further indicates that the refresh window is too close to the source update.To address this, adjust your morning refresh to 8:00 AM or 8:30 AM (UTC+8) to allow sufficient time after the source refresh, while maintaining the 2:00 PM refresh as your second daily run. This approach ensures both morning and afternoon refreshes remain within the Pro license limit of eight per day. Additionally, review your incremental refresh configuration to verify that the RangeStart and RangeEnd parameters are applied at the source level in a foldable step, and consider extending incremental refresh to additional tables to further enhance stability and performance
Regards,Microsoft Fabric Community Support Team.
Hi v-karpurapud,
I have set incremental refresh for some tables while some tables are still using full load refresh. Sometimes it still fail to load to latest date.
I set the auto refresh time at UTC+8, Daily and Time is 7.30am and 2pm, it appears that 2pm is stable which load to latest date.
The source was using import mode where the source is from data model built by my company IT team which they set refresh at 6am which normally finish before 7.30am.
I am currently using power bi pro licence.
Community SupportHi wleecwleec_2
The primary challenge relates to timing. Your Power BI Service dataset relies on an IT-managed model that refreshes at 6 AM, but this process may occasionally complete later than planned. As a result, when your dataset is set to refresh at 7:30 AM, it can begin before the source data is fully updated, leading to instances where the refresh completes without reflecting the latest data. The consistent stability of your 2 PM refresh further indicates that the refresh window is too close to the source update.
To address this, adjust your morning refresh to 8:00 AM or 8:30 AM (UTC+8) to allow sufficient time after the source refresh, while maintaining the 2:00 PM refresh as your second daily run. This approach ensures both morning and afternoon refreshes remain within the Pro license limit of eight per day. Additionally, review your incremental refresh configuration to verify that the RangeStart and RangeEnd parameters are applied at the source level in a foldable step, and consider extending incremental refresh to additional tables to further enhance stability and performance
Regards,
Microsoft Fabric Community Support Team.