Forum Discussion
Date format error
Hello everybody, when I update my input file PBI returns me an errore about Date Format. The problem is that it returns me that error only on a specific value, whereas it's able to convert all th...
Anonymous
Please check if you turn on the "Auto detect column type" and set a proper locale.
See: Flawless Date Conversion in Power Query
Regards,
Hello MFelix,
thx for your reply. I applied the steps you suggested and I got the same as you. Here come my question, hos do I fix this?
Hello Anonymous,
I was looking at you images and noticed that all of the information as the date of 12 January except the first two, are you sure there isn't a problem in the dates or as MarcelBeug refered to regional settings formats?
Regards
MFelix