Dateflow and Duration type

[John1]

I get a Something Wrong error message trying to create a dataflow with a duration data type. The M Query works in Desktop, but not in dataflow. There are workarounds, but is this a bug?

let
Source = Table.FromRows({{#duration(0,1,0,0)}},{"Duration"}),
#"Changed Type1" = Table.TransformColumnTypes(Source,{{"Duration", type duration}})
in
#"Changed Type1"

Something went wrong

An error occurred while processing recent changes made to one or more of your entities. Please check your queries and try again.

[v-shex-msft · Accepted solution]

HI @John1 ,

I think this should related to your data type, current power bi service side only support text, numeric, bool, date, time format, time duration seems not work.

Maybe you can consider to split it to multiple columns with numeric format.

Regards,

Xiaoxin Sheng