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.
In my report I have placed a card with the date and time of update, the problem is that while on my pc for example it is 2pm when updating the report in the cloud the card shows 5 hours later, that is, 7pm
Solved! Go to Solution.
Hi @Davidftm201068 ,
This is probably because your tenant (the service) is set to a different time zone than your PC. You would have to synchronize these two to get the same time OR you will have to use a measure or column addition to take the Tenant time and subtract a certain number of hours. This can get tricky though as you cross days and it is no longer just a "time subtraction".
Part of the issue may be that Power BI Service uses the UTC time. There is an idea to resolve this issue that you might want to vote for:
Proud to be a Datanaut!
Private message me for consulting or training needs.
HI @Davidftm201068,
As collinq said, your issue may be related to power bi service timezone offset.
I'd like to share a tip to add a DateTime field to your table, then you can use this field in the DAX formula to prevent the timezone conversion issue on power bi service side.
Steps:
Add a custom column to extract DateTime value from raw date field, then convert them to UTC format and manually add the timezone offset to get a fixed local timezone datetime.
How to add hours to DateTime data?
Functions | Descriptions |
DateTimeZone.ToUtc | Returns a DateTime value to the Utc time zone. |
#duration | Creates a duration value from days, hour, minute, and second. |
Regards,
Xiaoxin Sheng
Hi @Davidftm201068 ,
This is probably because your tenant (the service) is set to a different time zone than your PC. You would have to synchronize these two to get the same time OR you will have to use a measure or column addition to take the Tenant time and subtract a certain number of hours. This can get tricky though as you cross days and it is no longer just a "time subtraction".
Part of the issue may be that Power BI Service uses the UTC time. There is an idea to resolve this issue that you might want to vote for:
Proud to be a Datanaut!
Private message me for consulting or training needs.
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.