Forum Discussion
Expression.Error: We cannot convert the value null to type Number. mysteriously appeared
I'm working in an ERP reporting project and I have relatively complex PBI and PQ set with dozens of tables and processing steps. Everything were fine until yesterday when I started to get error E...
OK, I finally managed to solve this issue. Error message was in the end misleading.
The error "Expression.Error: We cannot convert the value null to type Number" happened already in earlier steps. For some reason it got expanded to all the columns at the later steps.
The root cause was unexpected values in the code list merged in earlier steps.
Finding the source of error is the key to solving the issue.
One of the ways I found helpful for finding the offending row is to use the "Keep Errors" option and understand the nature of the issue. The next step I take is to replace the error with null. This might or might not be of help to you.