Forum Discussion
Solved
Expression.Error: We cannot convert the value null to type List.
I created a query calling a custom function, and it is giving me the following error. I am connecting via API using a static URL Expression.Error: We cannot convert the value null to type List. ...
mahoneypat Anonymous I was able to resolve all issues replacing the "&" with "?". I am not sure of the reasoning behind it but I appreciate your time and help!
By carefully examining your query, identifying the source of the null values, and applying the appropriate solutions (like replacing null with an empty list or using conditional logic), you can resolve this "cannot convert the value null to type List" error in Power Query. The key is to be proactive in handling potential null values before they cause errors.