Forum Discussion
Dataflow - The dataflow model contains an unsupported type
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
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.
5 Replies
- v-janeyg-msft
Community Support
Hi, mayans
The dataflow indeed doesn't support duration type data. Maybe you can consider to split it to multiple columns with numeric format.
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.
- mayansFrequent Visitor
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 :).
- mayansFrequent Visitor
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
Community Support
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.
- kwinninghamFrequent Visitor
So instead of workarounds, why can't this just be fixed?