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?
If you have leading or trailing spaces, select the step before types are changed, right-click the column header - choose "Transform" - choose "Trim" (if it's not there choose "Text Transforms" first and then "Trim").
You may get a warning about inserting a step but just go ahead and click OK.