Forum Discussion

Niraj_vora0106's avatar
Niraj_vora0106
Helper III
4 years ago
Solved

Date Error

Hi community,    I'm getting this following error in my Date columns,  Can anyone please help me out as I've encountered this Error for the first time.  In Dates Column I'm getting this Error...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hey, 

    To avoid this issue, change regional settings of Power BI Dekstop

    Alternatively, you can just do it in PowerQuery. Change type using Locale 

    It's impoprtant to fist let Power Query  identify correctly date and then proceed with further transformations.
    E.g. if you have Date/Time, then first change it with Locale to Date/Time format and only then to Date 

    Hope this helps

     

amitchandak's avatar
amitchandak
Super User
4 years ago

Niraj_vora0106 , Can you check the data, I think there are different formats of date which is not working.

Also, check it before the first time the change data type is applied