Error.Expresion: We cannot convert null to logical

[ClaraSf]

Hi,

I have 10 queries appened in a new query (consolidate) and when I refresh all the queries, I got an error in consolidate "We cannont convert null to logical". I have checked the type of all the columns and they look good. When I try to find the error I can just find in the last row of consolidate "error" in all the columns but I do not know how to find it.

Do you have any idea?? I would any appreaciate any help!

I am new in this community so if you need some more data to be able to help, please let me know.

[v-jingzhang]

Hi @ClaraSf 

When appending multiple queries, the queries are appended in the order of their positions in the list one by one. 

You may go to the last query to be appended and check whether it has any error in the last row. If it does, try to solve the error in the original query. If the error row is redudant and doesn't affect any necessary rows, you can remove this row by using Reducing Rows > Remove Errors. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.