Forum Discussion
PowerQuery tranforming date from different locale stopped working?
I sometimes have to import CSV files from the Philippines, which contain date/time values with a M/DD/YYYY format. I'm not in the Philippines or US, so my default date format is D/MM/YYYY. Just openi...
Take this:
- Remove the Auto-Generated “Changed Type” Step
In Power Query Editor, delete the first “Changed Type” step that Power Query adds automatically. This step assumes your system locale and causes misinterpretation. - Manually Apply Locale Conversion
- Select the date column(s).
- Right-click → Change Type → Using Locale…
- Choose Data Type: Date/Time and Locale: English (United States).
- Reapply Data Types for Other Columns
Use the column header icons to set types for non-date columns. - Check for Numeric Locale Conflicts
If your data includes numbers with commas or periods, apply “Change Type Using Locale” to those columns too.
Yes! That worked!
Thank you!