Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
v-yuezhe-msft
Employee

@Anonymous ,

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

v-yuezhe-msft
Employee
Status changed to: Delivered