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...
Need Help
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 ?

    • Arul's avatar
      Arul
      Super User
      5 years ago

      Hi Anonymous ,

       

      2019-01-09 11:46:30 UTC

       

      This is the value in the column. I hope this would be helpful.

       

      Thanks,

      -Arul.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        You cannot do it because of 'UTC'. Get rid of it and then try to convert to date/time. Kindly accept this post as solution if it helped