Forum Discussion
Helper IIITime fields in Power BI display 5 hours behind the source data
Hi szub ,
Because Power BI service operates in the UTC time zone, and evaluates all locale based time functions in that time zone. Power BI Desktop evaluates them according to the locale of the user.
There are two workarounds for this situation;
In Power BI Desktop:On your powerBi desktop, go to File ==> Options and Settings ==> Options
On the dialog opened, select Reginal Settings under current file
Change the Locale for import to the English (your own country)
In Power BI Service:
use a fuction such as NOW()+TIME(8,0,0)
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IIIHi Binbin Yu,
I got this to work, but only if a time is populated. If a time was not populated in the field, I am getting 5am when it is blank in the source record. Since it is a time field I the Replace Value I can only enter 00:00 or 0 in place of null, and then it updates to 12:00am.
Thank you
Helper IIIHi Anonymous,
Do you have any suggestions on what to do when the date fields are blank from the source record and populate a value because of the Now & Time function?
Thank you,
szub