PowerBI Service changes the time when publishing the Dashboard

[arojorom]

Hi to every one, 

In one of my dashboards I put a marker that acts as a date refresh. The problem is that on the desktop it marks the correct time, but when I upload it to Service it goes from UTC +01:00 to UTC +00:00. I have not found a way to fix this error, but I understand that it may be related to the Service configuration. Can somebody help me?

[arojorom]

As @GilbertQ  suggested in his post. I created a new column in Power Query Editor and I used DateTime.From(DateTimeZone.FixedLocalNow()+ #duration(0,1,0,0))) to fix the error in PowerBi Service. On my Desktop is always one hour more, but in the web version, the current date and hour are OK. 

Thanks for your answer @GilbertQ!

[GilbertQ]

Happy to help!

[GilbertQ · Accepted solution]

Hi @arojorom 

All the Power BI Servers are set to the timezone of UTC 0:00

Power BI – Did you know ALL Power BI Services Servers are in UTC? Now how to handle it for Dates & T...