Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Timestamp issue

Hi,

 

Can someone explain to me why the timestamp in the Power BI Service is not according to the selected Arizona time zone when it comes to refreshing?

The Refresh timestamp in Power BI after refresh whereas it is really 2:28 PM here in Arizona....

 

 

How do I fix this??

 

Thank you,

Holly

Need Help
Tips and Tricks
Tutorial Requests
  • danextian's avatar
    danextian
    1 year ago

    thats is M. Applied step name is automatically generated so DAX AZ time is not needed.

6 Replies

  • danextian's avatar
    danextian
    Super User
    1 year ago

    Volatile functions like TODAY(), NOW() and the M equivalents are based on UTC. Consider using

    UTCNOW() + TIME(8,0,0)
or
UTCNOW() + DIVIDE ( 8,24 )

    Replace 8 with your UTC offset

  • pallavi_r's avatar
    pallavi_r
    Super User
    1 year ago

    Hi Anonymous ,

     

    As lbendlin has mentioned, Power BI Services operates in UTC time zone, so have to be adjusted using DAX or Power Query by adding offset to UTCNOW().

     

    Thanks,

    Pallavi

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Yes, I know it is running on UTC time zone. However, I am NOT getting anywhere with the DAX...I am not sure where I am doing this wrong? I tried in Excel and Power BI Power Query....


      DAX AZ TIME = DateTimeZone.SwitchZone(DateTimeZone.LocalNow(),-8,0)

       

      Is this expected??

       

       

      • danextian's avatar
        danextian
        Super User
        1 year ago

        thats is M. Applied step name is automatically generated so DAX AZ time is not needed.