Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
Hi @huonghill ,
Which data source you are using? I have tested it in my environment and it seems work fine when I replace values. Could you please share the power query code in advanced editor for further discussion?
Best Regards,
Yingjie Li
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.
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
@huonghill , refer if this can help
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |