Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
nickspizza
Helper I
Helper I

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.

 

 

4 REPLIES 4
Greg_Deckler
Community Champion
Community Champion

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

Hi @nickspizza ,

 

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

 

vkkfmsft_0-1629966432018.png

 

 

Best Regards,
Winniz

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

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors