Forum Discussion

huonghill's avatar
huonghill
Microsoft Employee
6 years ago
Solved

Error - OLE DB or ODBC error: [Expression.Error] We cannot convert the value null to type Logical

Hi,  I'm having the error mentioned in the post title. I do see null values in some columns (both number and text). However, when I replace null values with either 0 or "blank" or "none", PBI doesn'...
Need Help
Show and Tell
  • huonghill's avatar
    huonghill
    6 years ago

    Hi v-yingjl , 

    Thank you so much for your help! After a long search, I figured out that one column has a null values that causing a blank row in my table. It was a quick fix that I excluded null values in the transform data view. Your help is much appreciated

v-yingjl's avatar
v-yingjl
Community Support
6 years ago

Hi huonghill ,

Try like this in power query:

= Table.ReplaceValue(
    #"Changed Type","null","blank",Replacer.ReplaceValue,{"Column1","text"}
)

 

Remember that "null" and null are different in power query.

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

huonghill's avatar
huonghill
Microsoft Employee
6 years ago

Hi v-yingjl , 

Thank you so much for your help! After a long search, I figured out that one column has a null values that causing a blank row in my table. It was a quick fix that I excluded null values in the transform data view. Your help is much appreciated