Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
This still not fixed after all these years?
I'm having this problem right now - so i dont think that it is fixed!
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 ?
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
I'm talking about scheduling a refresh within the service, not anything to do with manipulation in Power Query, DAX etc
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.