Forum Discussion

nickspizza's avatar
nickspizza
Helper I
5 years ago

dataflow error convert decimal into type logical

My Dataflow cannot refresh. It gives me an error:  

 

Error: Expression.Error: We cannot convert the value 0.29032258064516131 to type Logical. Value = 0.29032258064516131. RootActivityId = e257f7c6-04cf-4cc0-b798-ca0971c75397.Param1 = Expression.Error: We cannot convert the value 0.29032258064516131 to type Logical. Value = 0.29032258064516131 Request ID: 7d3ccd44-1d4f-9a87-6dab-75499450c091.

 

Firstly, there are no columns that is set to a Logical or Boolean type. All the columns are text or decimal columns.

The only column with these kind of values is set to decimal. I don't understand why it's giving me this error.

 

 

Dataflow
Need Help

4 Replies

    • nickspizza's avatar
      nickspizza
      Helper I
      5 years ago

      Greg_Deckler  Yes I do. They look like this:

       

      Table.AddColumn(#"Added Custom4", "LTE Hybrid TGT", each if [Product] = "TM LTE Hybrid" and [Agent]=[Store] then [TGT] else if [Product] = "TM LTE Hybrid Renewal" and [Agent]=[Store] then [TGT] else if [Product] = "TBM LTE Hybrid" and [Agent]=[Store] then [TGT] else if [Product] = "TBM LTE Hybrid Renewal" and [Agent]=[Store] then [TGT] else null)
      • v-kkf-msft's avatar
        v-kkf-msft
        Community Support
        4 years ago

        Hi nickspizza ,

         

        I can not reproduct your problem, could you please share your dataflow model.json or sample data?

         

         

         

        Best Regards,
        Winniz