Dataflow date format is different in Power BI and Power Apps

[agranaas]

Hi,

The date format in dataflows is behaving differend in Power BI Dataflows and Power Apps Dataflows, and it does not seem to bother at all about the locale set in the transformation.

The input for these two queries are yyyymmdd:

In Power BI Dataflow this is the result - dates are formatted as mm/dd/yyyy

In Powerapps Dataflow the dates are formatted as dd/mm/yyyy:

None of the transformations seems to bother about the "Change column type with locale" "nb-NO" which should have displayed the dates as 31.12.2022 and 01.01.2023.

Im using the same browser in both cases here. 

OS language is UK English.

Browser language is set to UK English.

Power Query Project options are both set to use locale "Norwegian Bokmål (Norway)"

Please fix this Microsoft! This is really annoying.

Power Query script if you want to give it a try..

let

  Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwMjI0MjZUitUBc4wNDA2AnFgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [dateint = _t]),

  #"Changed column type with locale" = Table.TransformColumnTypes(Source, {{"dateint", type date}}, "nb-NO")

in

  #"Changed column type with locale"

[agranaas]

Hi @v-jialluo-msft 

Power Query / dataflow must use locale when we use it in the code. The case you are referring to is not a solution to the problem.

[v-jialluo-msft]

^{Hi @agranaas ,}

^{Here's a similar case, see if it helps your question}
Solved: Analytical dataflow Date format error - Power Platform Community (microsoft.com)

^{Best Regards,}

^{Gallen Luo}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}