TimeZone confusion - correct on DeskTop / wrong on Service

[Anonymous]

Hi there

Do hope there are a smart person out there who once for all can help alot of us out.

There are multible strings relating to the same issue and none of the really fix the issue for me. Only a "stupid" workarround is getting the right date/time on to the canvas at the PowerBi Service in mine setup.

Case short :

On the canvas I have shown a DateTime of last refresh of data. (not the latest refresh of the view on PowerBi.Service)
On the PowerBI Desktop the refresh Date/Time is shown correctly.

On the PowerBI Service the refresh Date is OK but Time are -2 hours.

The only workarround I can find (to handle this "error" from Desktop to Service) are to add a new colum with a +2 hours:

Column 1 : = #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}})

Column 2 : = Table.AddColumn(Source, "Data Opdaterings Dato/Tid", each DateTime.From(DateTimeZone.FixedLocalNow()+ #duration(0,2,0,0)))

But this will leave me with a PowerBI Desktop version witch are "not rigth".

There must be a way for PowerBI Service to do it right without the workarround.

Picture below shows:

Top = PowerBI Service

Middle = PowerBI Desktop

Buttom = PowerBI Power Query.
Green = the right time. (the +2min. are do to upload time etc :-))

Picture to the right, show the settings on PowerBI Service.

  

[ibarrau]

Hi. You can try converting that DateTime column in Edit Queries or Transform Data using locale. 

https://www.oraylis.de/blog/local-date-formats-in-power-bi#:~:text=Here%20comes%20the%20easy%20way,s....

That should keep it the same way.

I hope that helps 

[Anonymous]

I've tried that as well and sadly it did not make any difference.

[Greg_Deckler]

@Anonymous Is it a true statement that you are in a time zone (physically) that is not Central European Summer Time? From what I can tell, that is where your Power BI Service Tenant is provisioned?

[Anonymous]

I am located in Denmark witch are +1 hour from GMT and +7 from CST time.