Update date wrong time

[ATFabi]

Hello together,

we have been observing a strange behavior in Power BI for a few months now where unfortunately we can't find a solution.

We have a field displayed in our reports and dashboards that shows the last update date.

This shows the correct time in Power BI Desktop, here (we think) all settings were checked correctly and we could find the correct time everywhere.

However, when we now upload the report to the cloud, the wrong update date is displayed here. It always shows there one hour earlier.

If I now dock to Power BI locally, for example via Excel, and get the information in via the "Update date" field, I also find the wrong time here. A query in Power BI via DateTime.FixedLocalNow() also shows the wrong time.

I have also already checked our settings on the part of Microsoft 365 and unfortunately cannot find any incorrect time, time zone, etc. here.

Do you have any idea where a wrong setting can be stored here?

Many thanks in advance!

[v-rzhou-msft · Accepted solution]

Hi @ATFabi ,

Please try this workaround:

1) Right click on dates column > Change Type > Using Locale..

2) Select the date type as date/time of your respective location

3) Refresh and publish to Power BI service..

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.