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