Forum Discussion
Helper IIITime fields in Power BI display 5 hours behind the source data
Hello,
I am having an issue with time fields displaying 5 hours behind the source data in Power BI reports. I have checked the regional settings and they are correct. For example, the time on a record in source data is showing 4:00pm and in Power BI it is showing 11:00am or it may show 7:00am in the source data and in Power BI is shows 2:00am. I am not doing anything to caluculate time, I am just trying to report the time as listed on the source data.
Thank you!
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.
6 Replies
- otravers
Community Champion
The Power BI service operates on UTC.
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.
szubHi Binbin Yu,
I appreciate the info. I had checked the regional settings and they were correct in Power BI Desktop. I can't figure out how to add the function to Power BI service though. Can you give me some guidance on that?
Thank you!
Hi szub ,
Please add this function in the Power BI Desktop firstly, then save the report and publish it to the Power BI Service.
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.
