Forum Discussion

John1's avatar
John1
Frequent Visitor
7 years ago
Solved

Dateflow and Duration type

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.

Dataflow
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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