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