Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power Query convert date to datetime

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 !

Need Help
  • HotChilli's avatar
    HotChilli
    4 years ago

    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?

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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 

  • HotChilli's avatar
    HotChilli
    Community Champion
    4 years ago

    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?