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't let me apply the change. The same error pops up

 

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

 

Please let me know how I fix this. Your help is much appreicated.

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

5 Replies