Dataflow - The dataflow model contains an unsupported type

[mayans]

hey pbi team,

i realized that a dataflow can't save when the type of the column is set to type duration. any way to solve this?

best,

Mayan

[mayans]

to sum up you just need to chose a different data type for the dataflow which you later in the desktop version change back to duration. this can be achieved in many different ways, either by changing to time type, spliting it into different columns and then use combine or even change it to total time seconds and the convert it back to duration.

Thanks @v-janeyg-msft for the tips :).

[mayans]

@v-janeyg-msft could I put it in time or text format untill the dataflow gets pulled into a pbi desktop file and then there convert it back to duration or will that mess up the data?

[v-janeyg-msft · Accepted solution]

Hi, @mayans 

I try it, my dataflow without a data model can be changed. As long as the power query in desktop can be opened, it should be changed to the duration type. Of course, you can also recombine the split columns, as long as you can use powerquery in the desktop, there are many ways. You can check it.

Best Regards

Janey Guo

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

[kwinningham]

So instead of workarounds, why can't this just be fixed?

[v-janeyg-msft]

Hi, @mayans 

The dataflow indeed doesn't support duration type data.  Maybe you can consider to split it to multiple columns with numeric format. 

Reference: Dataflows Limitations, restrictions and supported connectors and features - Power BI | Microsoft Doc...

If it doesn't solve the problem, Please feel free to ask me.

Best Regards

Janey Guo

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