Forum Discussion

agranaas's avatar
agranaas
Frequent Visitor
3 years ago

Dataflow date format is different in Power BI and Power Apps

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"

 

 

Dataflow
Need Help

3 Replies