cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jthomson
Solution Sage
Solution Sage

Refresh timings and daylight savings

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

3 REPLIES 3
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors