Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to 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.
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.