Forum Discussion

AMD0791's avatar
AMD0791
Advocate IV
10 months ago
Solved

PowerQuery LocalNow() timezone *not* UTC in the service

  The documentation here indicates that LocalNow() in PowerQuery will return UTC time in the service. Local, fixed, and UTC variants of current time functions - PowerQuery M | Microsoft Learn   I...
Need Help
  • AMD0791's avatar
    AMD0791
    10 months ago

    Thank you for your response, except you missed the key point.  When I publish to the service and refresh the data in the service, the results for LocalNow() in PowerQuery are UTC -7, and not UTC as specified in the documentation.   LocalNow() returns UTC -7 and UTCNow() returns that actual UTC time.   I'm trying to determine how it decides to use that timezone for LocalNow() instead of UTC.

GilbertQ's avatar
GilbertQ
Super User
10 months ago

Hi AMD0791 

 

That is really interesting because as per the documentation it should all be returning the time in UTC. If that is happening in your case, I would rather use the UTCnow() function and then use the duration offset to ensure that the term is always accurate as expected.