Date Problem LocalDate PBI Service Desktop

[AilleryO]

Hi,

I am facing a strange display in PBI Service regarding a date-time.

I'm using a table to get the last refresh date with 2 columns, one in LocalTime and the other in UTC date.

Very simple table like this :

let
Source = #table(type table[LocalDate=datetime, UtcDate=datetime], {{DateTime.LocalNow(),DateTimeZone.UtcNow()}}),
    #"Type modifié" = Table.TransformColumnTypes(Source,{{"LocalDate", type datetimezone}, {"UtcDate", type datetimezone}}),
    #"Année insérée" = Table.AddColumn(#"Type modifié", "Année", each Date.Year([LocalDate]), Int64.Type),
    #"Colonnes permutées" = Table.ReorderColumns(#"Année insérée",{"LocalDate", "Année", "UtcDate"})
in
    #"Colonnes permutées"

On PBI Desktop everyhting works fine and the time and date are correct (in table and in visuals)

On PBI Service, if I look in the drop down menu (from title bar) I have the correct date and time displayed (see image below).

But on the field on my page I have a time 2 hours behind.

(I'm in France and my data are stored in Netherlands).

If i look at the update date-time in the list view for my dataset and my report, update date-time are correct (see image below).

So it works fine everywhere except on my report, 😞 and as a consequence it is not correct neither on my dashboard.

Does anyone have a clue ?

Thanks

Olivier

[lbendlin]

Please read https://radacad.com/solving-dax-time-zone-issue-in-power-bi  and see if it helps.

[AilleryO]

Hi,

Thanks for your reply and suggested link.

My problem being I don't know what correction I should make since there is no Time Zone between Netherlands and France ?

I can make a query as suggested in the link to retrieve desired time zone... Ok but I love to understand things...

Obvioulsy I could make a 2 hours correction but without knowing where it comes from ?

So I am wondering where is that time coming from ? Greenland ?

Does anyone else have experienced something like that ?

[lbendlin · Accepted solution]

The Power BI service runs on UTC.