cancel
Showing results for 
Search instead for 
Did you mean: 
0

Now() gives wrong DateTime on Online Version (Now() == UTCNow())

The Online version of Power BI Report does not use the user locale to define Now(), returning the same value from UTCNow()

 

Metrics:

NowLocal = Now()

NowUTC = UTCNow()

 

Small change on time due to screen capture at different times while writing...

 

See Results:

Power BI Online:

online.JPG

Power BI App:

local.JPG

 

Windows Clock:

windows.JPG

 

Status: Delivered
Comments
Moderator

@iamj ,

NOW() function will return the UTC time in Power BI Service, this is an expected behavior. To get correct local time, you can add time difference in your DAX formula, for more details, please take a look at this blog: http://radacad.com/solving-dax-time-zone-issue-in-power-bi.

Regards,
Lydia

Moderator
Status changed to: Delivered