Request from power query does not display the right data

[Eraaz]

Hello, I have some request in my excel sheet that are loaded every day by a macro.
The problem is the data that are recovered are not the same as the data that are on the preview of the power query request.
The difference is always on the hour.
Do you have an idea why ?
Thanks

 

[arthurbr]

Perhaps you need to display dates using locale in PQ ? Set a locale or region for data (Power Query) - Microsoft Support

 

[Eraaz]

Thanks for the reply.
I don't think it's region related. Because if I reload more the correct time is display.

The code to display the time is this.

let
    Source = PertesDataconnexion,
    #"Autres colonnes supprimées" = Table.SelectColumns(Source,{"Column53"}),
    #"Premières lignes supprimées" = Table.Skip(#"Autres colonnes supprimées",3),
    #"Lignes vides supprimées" = Table.SelectRows(#"Premières lignes supprimées", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null}))),
    #"Ajout 1 jour" = Table.AddColumn(#"Lignes vides supprimées", "Date ini", each Date.AddDays([Column53],1)),
    #"Colonnes supprimées1" = Table.RemoveColumns(#"Ajout 1 jour",{"Column53"}),
    #"Personnalisée ajoutée" = Table.AddColumn(#"Colonnes supprimées1", "Heure diff", each Duration.Hours(
    DateTime.Time(DateTime.LocalNow())-
    DateTime.Time(DateTimeZone.UtcNow()))),
    #"Personnalisée ajoutée1" = Table.AddColumn(#"Personnalisée ajoutée", "Date", each if [Heure diff] = 1
        then Date.ToText([#"Date ini"], "yyyy-MM-dd"&"T08:00:00Z")
        else Date.ToText([#"Date ini"], "yyyy-MM-dd"&"T07:00:00Z")),
    #"Colonnes supprimées" = Table.RemoveColumns(#"Personnalisée ajoutée1",{"Heure diff"}),
    #"Index ajouté" = Table.AddIndexColumn(#"Colonnes supprimées", "Index", 0, 1, Int64.Type),
    #"Autres colonnes supprimées1" = Table.SelectColumns(#"Index ajouté",{"Date", "Index"})
in
    #"Autres colonnes supprimées1"