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
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

      • Arul's avatar
        Arul
        Super User
        5 years ago

        Hi Anonymous ,

        I have removed UTC but still it is throwing me same error.

         

        Thanks,

        -Arul.