Forum Discussion

obriaincian's avatar
obriaincian
Resolver I
4 years ago
Solved

Power BI Error - Cannot convert text into date type

I have a table in Power BI with blanks and also Text in the following format "01/11/2021 00:00:00"

 

When I highlight this date column and attempt to convert to data type to date I get an error. "we cannot automatically convert the column to date type".

 

I'm not sure what's causing it to error. I have other columns that are formatted the same and they converted no problem.

Thanks

Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    HI obriaincian ,

    Pls refer the below:

    similar error:

    Click  transform data:

    Adjust to date/time:

     

    Apply and close:

     

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien

     

2 Replies

  • gauthamboppana's avatar
    gauthamboppana
    Solution Specialist
    4 years ago

    obriaincian  -  In Power Query editor, try splitting the column by space delimiter and then convert the Date column to Date Type

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    4 years ago

    HI obriaincian ,

    Pls refer the below:

    similar error:

    Click  transform data:

    Adjust to date/time:

     

    Apply and close:

     

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien