Forum Discussion

obriaincian's avatar
obriaincian
Icon for Resolver I rankResolver 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. "w...
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

     

gauthamboppana's avatar
gauthamboppana
Icon for Solution Specialist rankSolution 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