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

     

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

Hi, Niraj_vora0106 

 

The problem is what's your original data format. Normal date formats don't go wrong. Can you show it so we can help you fix it?

 

Best Regards,
Community Support Team _ Janey