Scheduled Refresh Not Updating Data before UTC 0:00

[BucketBruh]

Hi team

Apologies if this has been asked before and I missed it. I have a report that is set to auto refresh every half hour between 7:30am and 5pm NZT. The auto refresh happens on time however the data in the report does not update until after 1pm NZT. 1pm NZT is UTC 0:00.

I've looked around and can't find a solution that works. No matter how I try to change my data or measures, the auto refresh simply will not change any data when refreshing until after 1pm NZT.

Any help would be appreciated and let me know if more info is needed

[nilendraFabric]

Hello @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

[BucketBruh]

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-aatheeque]

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!

[BucketBruh]

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

[v-aatheeque · Accepted solution]

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!

[v-aatheeque]

Hi @BucketBruh ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know

Thank you.

[v-aatheeque]

Hi @BucketBruh ,

We haven’t heard back from you regarding the last response, so we wanted to check if your issue has been resolved.

If it has, please click 'Accept Answer' and 'Yes' if you found the response helpful. If you have any further queries, feel free to let us know.

Thank you!

[v-aatheeque]

Hi @BucketBruh 

We wanted to follow up regarding your recent inquiry to see if your issue has been resolved.

If your issue has been addressed, please click 'Accept Answer' and select 'Yes' if you found our response helpful.

If you have any further questions or need additional assistance, please don't hesitate to reach out.

Thank you !