Refresh timings and daylight savings

[jthomson]

Hi,

Is it possible to set up a scheduled refresh that correctly adapts to our local timezone? It seems as if the only option I can see in the dropdown is UTC plus or minus some number of hours, so after the UK switched to BST over the weekend, a report that was timed to update at 9am will now update at 10am. Changing potentially hundreds of reports every six months is clearly not ideal, can we not set up a refresh so that it will update at 9am UK time, regardless of what that is in relation to UTC?

edit - this now appears to have rectified itself automatically in the last few hours, no idea why

[v-shex-msft]

HI @jthomson ,

You can take a look at following blogs which mentioned daylight saving calculation:

Daylight Saving Time And Time Zones In M

Convert UTC to Local Time with Daylight Savings Support in Power BI

Regards,

Xiaoxin Sheng

[jthomson]

I'm talking about scheduling a refresh within the service, not anything to do with manipulation in Power Query, DAX etc

[AndrewPNZ]

This last weekend New Zealand changed from GMT+13 to GMT+12. A report that was scheduled to run at 8 PM ran at 7 PM, and retrieved data that was in the middle of being prepared for upload. This resulted in the Power BI report having garbage data in the automatically emailed post-refresh email. This was followed by the dataset updating correctly at 8 PM, but with no post-refresh email. This led to an errant Power BI report being sent to my manager.

I support @jthomson's request to have Power BI dataset refresh schedules account for changes in timezone offsets.