Forum Discussion

_Nick_'s avatar
_Nick_
Regular Visitor
1 year ago
Solved

Scheduled Subscription Daylight Savings Time Bug

Background: I'm a North American operation running continental (12 h) shifts. As of March 9, we're running local Daylight Savings Time. Since March 10, I have Power BI reports summarizing each shift's production details going out twice a day at 8:30 (AM and PM) local DST using the Power BI Service "Subscriptions" feature; the timezones in this feature are labelled relative to UTC.

 

Problem: Suddenly, starting Sunday, March 30, these emails are showing up in our inboxes at 7:30. The only thing that has changed is that EUROPEAN Daylight Savings Time started Sunday, March 30 at 1:00 AM.

 

What's going on? Are the Timezones labelled as UTC but the Scheduled Time is actually relative to European Daylight Savings Time schedules?

 

  • lbendlin-- thanks for the suggestions

     

    After some back and forth with MS Support, I have confirmed that, contrary to initial appearance, if you want purely UTC time, you need expressly select the "Coordinated Universal Time" timezone option. While the other "(UTC)" don't visually indicate it, they do fluctuate according to the indicated region's daylight saving time changes.

     

     

    RE: Daylight Saving(s) -- eesh, I've been saying it wrong for 30 years... that's gonna be a tough habit to break...

2 Replies

  • _Nick_'s avatar
    _Nick_
    Regular Visitor

    lbendlin-- thanks for the suggestions

     

    After some back and forth with MS Support, I have confirmed that, contrary to initial appearance, if you want purely UTC time, you need expressly select the "Coordinated Universal Time" timezone option. While the other "(UTC)" don't visually indicate it, they do fluctuate according to the indicated region's daylight saving time changes.

     

     

    RE: Daylight Saving(s) -- eesh, I've been saying it wrong for 30 years... that's gonna be a tough habit to break...