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