Forum Discussion

unclejemima's avatar
unclejemima
Icon for Post Patron rankPost Patron
9 years ago

Subscription sent at wrong time but timezone correct

I've got a scheduled refresh thats set to update data everynight at 10pm MST...but I got the reports sent to me a 6:00pm last night.   I have the scheduled refresh set at 10pm MST...so I'm not sure...
Need Help
unclejemima's avatar
unclejemima
Icon for Post Patron rankPost Patron
9 years ago

Email sent at proper time tonight only the date stamp in the email was still wrong time zone

 

It was sent at 10pm MST but detail in subscription shows...

 

The image above was generated at 4/30/2017 4:08:56 AM UTC

 

Is anyone else having this happen with their subscriptions?

  • v-caliao-msft's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    unclejemima,

     

    Currently, you will only get emails when the data changes when subscribe a report. So when setting schedule refresh for this report dataset, please select your local timezone, so that you data will refresh on proper time. And you can get the email on a proper time.

     

    For the issue
    The image above was generated at 4/30/2017 4:08:56 AM UTC
    In Power BI services, your local will convert to UTC time. Currently, there is not such a option to change this time to your local time. You can add a local time to your report, please refer to the link below to see how to do it.
    http://community.powerbi.com/t5/Service/changing-timezone-of-powerbi-service/td-p/153663

     

    Regards,

    Charlie Liao

    • unclejemima's avatar
      unclejemima
      Icon for Post Patron rankPost Patron
      9 years ago

      I get it but I don't.


      When viewing reports in Power BI I'm using NOW() function.  This displays my local timezone (MST) in the desktop application.


      When I'm in the Web Service it will display the timezones as UTC.

       

      Thats fine, so I can create a new column in called NOW(-6) to get to MST, no?  But when I'm looking at the report in desktop I'll get the wrong time as I'll put -6 from the local...but in the online it will show correct.

       

      So I have to do right for one, wrong for the other?

       

      Let me know

      • v-caliao-msft's avatar
        v-caliao-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        unclejemima,

         

        When viewing reports in Power BI I'm using NOW() function.  This displays my local timezone (MST) in the desktop application. When I'm in the Web Service it will display the timezones as UTC.

        Currently, it's default behavior in current version of Power BI. So in your report, you'd better add two time, one is for local time, and another one is for UTC time.

         

        Regards,

        Charlie Liao