Forum Discussion

Arul's avatar
Arul
Super User
5 years ago

Data Conversion Error

Hi All,

 

I have date/time value in one of my column while i am trying to convert this column into date/time type in PBI it gives me the following error. "We cannot automatically convert the column to Date/Time type".

 

Thanks,

-Arul.

Need Help

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Kindly give more details. A screenshot of column with the process of how you are trying to change the data type.

    • Arul's avatar
      Arul
      Super User
      5 years ago

      Hi Anonymous , Column is having date/time values, I just need to convert it into Date/Time data type.

       

      Thanks,

      -Arul

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Not helpful. Can you paste a value from the column ?

  • PC2790's avatar
    PC2790
    Community Champion
    5 years ago

    Check if the Locale regional settings in your Power BI Query is as per your region.

    Go to the column, right click > Change Type --> Using Locale

    Selecting the right Locale according to your region will be able to parse your date.

    Make your that you have the column in Text before performing the above operation.

    • Arul's avatar
      Arul
      Super User
      5 years ago

      Hi PC2790 , I have checked my locale eveyrthing is fine. But i am getting the same error again.

       

      Thanks,

      -Arul.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Arul ,

     

    Did you delete the wrong steps before you did the solutions for Anonymous  and PC2790 ? If you do not delete the wrong step, you will not get the correct result.

    You should remove the Change type step, and then perform the above steps.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.