dataflow error convert decimal into type logical

nickspizza · ‎08-22-2021

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.

Greg_Deckler · ‎08-22-2021

@nickspizza Do you have a custom column anywhere doing some sort of calculation?

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

nickspizza · ‎08-24-2021

@Greg_Deckler

v-kkf-msft · ‎08-26-2021

Hi @nickspizza ,

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

Best Regards,
Winniz

nickspizza · ‎08-23-2021

@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)