Forum Discussion
Scheduled Refresh Not Updating Data before UTC 0:00
Hi BucketBruh ,
Apologize for the issue you are facing.
Since Power BI Service operates on UTC time, scheduled refreshes and published reports may not correctly align with New Zealand Time (NZT) due to daylight saving adjustments.When scheduling a refresh, choose UTC+12:00 Auckland/Wellington (instead of UTC+13:00) as below :
Ensure scheduled refresh times match NZ business hours.
If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
If you continue to face issues, feel free to reach out to us for further assistance!
Super UserHello BucketBruh
All scheduled refreshes in Power BI Service are based on UTC time, regardless of your local time zone. This means that your refresh schedule set for 7:30 AM to 5 PM NZT is actually interpreted as 6:30 PM to 4 AM UTC
https://www.linkedin.com/pulse/power-bi-service-time-differences-how-fix-aaron-watsky
Modify your scheduled refresh times to align with when your data source updates in UTC. For example, if your data source updates at 1 PM NZT (UTC 0:00), schedule the refresh shortly after this time
Or Use formulas to adjust for time zones within Power BI.
Hope this helps.
please accept the answer if this is helpful
Thanks
Hi there
Thank you for your response. I'm not sure it's applicable as my data source is an odata feed and should update whenever requested. Not at a specific time.
The issue is that although the refreshes happen at the correct time, the data on the report does not refresh until 1pm when auto refreshed. If I manually refresh, everything is perfect. I'm not sure why there's a disconnect between the two
v-aatheequeCommunity Support
Hi BucketBruh ,
Thank you for your question regarding the data refresh issue in Power BI. It sounds like you've already identified that manual refreshes work correctly, but the scheduled refreshes are not reflecting the latest data until 1 PM NZT. Here are some steps to troubleshoot and resolve the issue:
- Ensure that your Power BI Service is set to New Zealand Time (NZT). You can verify this by going to your workspace, selecting the dataset, and checking the scheduled refresh settings. Make sure the time zone is set to NZT (UTC+13/12) as shown below :
- Confirm that your data source is indeed updating new records before the scheduled refresh time. If the data source only updates after 1 PM NZT, Power BI will refresh but won’t have new data to pull until that time.
- If your data source or any transformations in Power BI are using UTC, there may be a mismatch. Consider converting timestamps explicitly in Power Query using DateTime.AddZone() to ensure they align with NZT.
- If you are using an on-premises data gateway, ensure that it is updated and running correctly. Restarting the gateway service can sometimes resolve connectivity issues.
If this answer helped resolve your issue, please consider marking it as the accepted answer. And if you found my response helpful, I'd appreciate it if you could give me kudos. Thank you!
Hi there
Thank you for your response. I've gone over all these steps and none of them help. It's definitely a problem with the power BI service and not the power BI application as manually refreshing and publishing in the app is perfect.
The auto refresh and publish of power bi service just doesn't seem to understand the differences between NZT and UTC
