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

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