Error in update hour in card

[Davidftm201068]

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

[v-shex-msft]

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

[collinq · Accepted 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:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32123752-power-bi-service-recogni...

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!