Power BI Error - Cannot convert text into date type

[obriaincian]

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

[v-luwang-msft · Accepted solution]

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

[gauthamboppana]

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