DateTimeZone.FixedUtcNow Function in Power Query

The DateTimeZone.FixedUtcNow function is a specialized function in Power Query (M language) that returns the current UTC date and time with a fixed UTC timezone offset (+00:00).

Syntax

Example:

Power Query M

let
    Source = DateTimeZone.FixedUtcNow()
in
    Source        

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

Behavior

• Returns the current UTC date and time when the function is first called during query evaluation
• Maintains that same value throughout the entire evaluation (unlike DateTimeZone.UtcNow() which might return different values if called multiple times)
• Always includes the UTC timezone offset (+00:00)