Data Conversion Error

[Arul]

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.

[Anonymous]

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.

[PC2790]

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]

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

Thanks,

-Arul.

[Anonymous]

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

[Arul]

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

Thanks,

-Arul

[Anonymous]

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

[Arul]

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]

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]

Hi @Anonymous ,

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

Thanks,

-Arul.

[Anonymous]

Interesting as I am able to resolve the issue.

Can you share the exact steps performed by you ?