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,
As of today latest solution available change type using Locale. There is the last option provided "Using Locale....".It seamlessly converts datatype based on selected locale. No more need to update the PC's regional setting.