Forum Discussion
Expression.Error: We cannot convert the value null to type Number. mysteriously appeared
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.
I had a similar issue. I noticed there was one row that was blank/null. I removed it by going Home -> Remove Rows -> Remove Blank Row, and then re-doing whatever transformation I neeed to do before getting the error, and am no longer recieving an error.
Here is the PowerBI article I used to fix my issue - Remove blank/null rows: Solved: Delete all the row when there is null in one colum... - Microsoft Power BI Community