Forum Discussion

Richard_Bowmaker's avatar
Richard_Bowmaker
Copper Contributor
Aug 10, 2025

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...
BI & Data Analysis
excel
Kidd_Ip's avatar
Kidd_Ip
MVP
Aug 12, 2025

Take this:

 

  1. 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.
  2. 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).
  3. Reapply Data Types for Other Columns
    Use the column header icons to set types for non-date columns.
  4. Check for Numeric Locale Conflicts
    If your data includes numbers with commas or periods, apply “Change Type Using Locale” to those columns too.

Resources