Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Time Zone issue after publishing report

Hi All,     For Shift, I have created a calculated column as below   Shift = IF( HOUR ( NOW() ) >= 6 && HOUR( NOW() ) < 18, Table[isDayshift], IF(Table[isDayshift] = 1, 0, ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    In Power BI Service, the now() function will return the UTC time. We can't set the time zone on Power BI Service. To get the correct local time. We can switch time zone when add a custom column. I have tested it on my local environment.

     

    Regards,

    Frank

  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

     

    Regards,
    Frank

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous ,

 

In Power BI Service, the now() function will return the UTC time. We can't set the time zone on Power BI Service. To get the correct local time. We can switch time zone when add a custom column. I have tested it on my local environment.

 

Regards,

Frank

  • MartinBragg's avatar
    MartinBragg
    Regular Visitor
    4 years ago

    Hi, I have worked through the solution in this thread and my two UTC date/time fields do get converted properly to my locale (GMT -6, US Central time) in Power BI Desktop.  However, when publishing my report back to the Power BI Service online, my date/time fields seem to be back in UTC format and are not correct.   Is there any additional troubleshooting that can be done on this?
    -Source Date/Time field data is in a SharePoint Online list and is correct.
    -Power BI Desktop pulls it in as UTC date/times.

    -Custom columns created that take the original UTC date/time fields and converts them to my locale using the TimeZone Switch code.  All values are corrected.  I then update my visual to include those two new calculated fields.  

    -Publish back to the online service and the values are incorrect again.

    Any help on this is appreciated.  *highly odd and frustrating to me*

    Thanks, 

    Martin

    • RobotRising's avatar
      RobotRising
      Frequent Visitor
      3 years ago

      Having the same exact problem here, used a custom column to change to eastern and works on desktop, briefly shows the right time in cloud after publish but on refresh the times go back to UTC...why is this so difficult? 

       

      did you ever figure out a solution?

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Anonymous ,

     

    Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

     

    Regards,
    Frank

  • MOOREJEFFREY's avatar
    MOOREJEFFREY
    Frequent Visitor
    2 years ago

    Is the setting "Use UTC Time" now correct this issue? I have the same problem and am using the work around. It looks like this might be addressed in the image below. Please advise. Thank you for your time.