Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to Solution.
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.
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.
Hi 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.
Hi 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
Hi @v-binbinyu-msft,
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
The Power BI service operates on UTC.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
84 | |
67 | |
63 | |
62 |
User | Count |
---|---|
208 | |
121 | |
112 | |
79 | |
70 |