DateTimeZone.UtcNow Function in Power Query

The DateTimeZone.UtcNow function in Power Query returns a DateTime value set to the current system date and time in the Utc timezone (the GMT timezone).

Syntax

DateTimeZone.UtcNow() as datetimezone

Example: Get the current date & time in UTC.

Power Query M

let
    Source = DateTimeZone.UtcNow()
in
    Source

The output of the above code is 2025-04-12T04:29:28.8476223+00:00.

Key Features

UTC Standard Time: Always returns time in UTC (+00:00 offset).
Dynamic: Updates each time it is called (unlike FixedUtcNow, which remains static during evaluation).
No Timezone Dependency: Unlike DateTime.LocalNow, it is unaffected by the local machine's timezone.

Previous Next