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

[StephenF]

This still not fixed after all these years?

[MaddogMikeB_A_G]

I'm having this problem right now - so i dont think that it is fixed!

[GrahamDean]

Is this still unresolved ?   I am looking at using the PBI Service and setting up data set refreshes and they are linked only to a specific UTC time with no allowance for daylight saving...  Does this mean that when daylight saving ends (and starts) all my reports will change their refresh schedule by an hour ?  Is this acceptable given the potential nature of the reports ?

[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.