Forum Discussion

mayans's avatar
mayans
Frequent Visitor
5 years ago
Solved

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's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity 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. 

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

    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.

  • mayans's avatar
    mayans
    Frequent 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 :).

  • mayans's avatar
    mayans
    Frequent 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's avatar
      v-janeyg-msft
      Icon for Community Support rankCommunity 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.

      • kwinningham's avatar
        kwinningham
        Frequent Visitor

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