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
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Aug 12, 2025

I can't reproduce that

let
    Source = Csv.Document( File.Contents("G:\Downloads\test.csv"),
        [Delimiter=",", Columns=4, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    PromoteHeaders = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    DeclareType = Table.TransformColumnTypes( PromoteHeaders,
        {
            {"RUN_TIME", type date},
            {"TIME_INTERVAL", type datetime}
        }, "en-US")
in
    DeclareType

Perhaps you may share csv file

Resources