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.
I have created a report for a users timesheet - It shows the time for Travel Start, Work Start, Work End and Travel End. On power BI desktop the times are correct I.e 06:00 Travel Start, 09:00 Work Start etc, In BI service the time are 1 hour behind, I've seen lots of sites discussing UTC but can't figure out how to apply so the times are correct when published.
Thanks
Solved! Go to Solution.
Hi @achester75 ,
The Today() function on the Power bi service returns today’s value according to the UTC() time zone, while the Today() function on the Power bi desktop shows the computer’s system time.
You can try to add a + time() function after your time measure to display the time in your local time zone to the power bi service.
For example:
I used now(), my local time displayed is: 2022.5.9 2:06:33 PM.
Using the function now()+TIME(8,0,0), in Power BI Desktop, 8 hours will be added from the time in our local time zone.
Desktop:
Publishing to Power BI Service will change the UTC time to my local time zone with minus 8 hours :
So, as you mean, in Power BI Service, the time is 1 hour late.
Use the function +/-TIME(1,0,0)
This is the related document, you can view this content:
https://www.thepoweruser.com/2019/10/21/handling-different-time-zones-in-power-bi-power-query/
https://radacad.com/solving-dax-time-zone-issue-in-power-bi
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @achester75 ,
The Today() function on the Power bi service returns today’s value according to the UTC() time zone, while the Today() function on the Power bi desktop shows the computer’s system time.
You can try to add a + time() function after your time measure to display the time in your local time zone to the power bi service.
For example:
I used now(), my local time displayed is: 2022.5.9 2:06:33 PM.
Using the function now()+TIME(8,0,0), in Power BI Desktop, 8 hours will be added from the time in our local time zone.
Desktop:
Publishing to Power BI Service will change the UTC time to my local time zone with minus 8 hours :
So, as you mean, in Power BI Service, the time is 1 hour late.
Use the function +/-TIME(1,0,0)
This is the related document, you can view this content:
https://www.thepoweruser.com/2019/10/21/handling-different-time-zones-in-power-bi-power-query/
https://radacad.com/solving-dax-time-zone-issue-in-power-bi
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.