Power Query convert date to datetime

[Anonymous]

Hello guys,

The Power Query convert itself all my date (dd/mm/yyyy) columns to datetime (dd/mm/yyyyy 00:00:00).

I would like to keep it in the original type without needing to transform the type or redefine the format in the modelisation tab.

Thank you in advance !

[HotChilli · Accepted solution]

So it looks like you have solved the issue which is probably that powerbi has automatic type detection switched on and it's made an assumption of datetime instead of date.  So it's not really a problem, more a nuance.

But you now seem to have edited the step and everything is good?

[HotChilli]

Can you post the Advanced Editor code here please?

[Anonymous]

Hi,

here below the code 

let
    Source = OData.Feed("ODATA FLUX LINK", null, [Implementation="2.0"]),
    #"Création CléAgrégée" = Table.AddColumn(Source, "CléAgrégée", each [CAMPAGNE]&[D_ORGA]&[D_CTRL]),
    #"Colonnes renommées" = Table.RenameColumns(#"Création CléAgrégée",{{"STATUT_INDICATEUR", "Statut indic."}}),
    #"Date extraite" = Table.TransformColumns(#"Colonnes renommées",{{"CREATE_TIME", DateTime.Date, type date}, {"FINISH_TIME", DateTime.Date, type date}, {"CLOSING_TIME", DateTime.Date, type date}, {"DATE_FROM", DateTime.Date, type date}, {"DATE_TO", DateTime.Date, type date}}),
    #"Type modifié" = Table.TransformColumnTypes(#"Date extraite",{{"DATE_HEURE_EXTRACTION", type datetime}})
in
    #"Type modifié"

I had to to transform columns to date in waiting