Forum Discussion
Dataflow Gen2 MashupException.Error We cannot convert the value null to type Number
Hi v-kpoloju-msft, rohit1991 and collinq. I found the solution! The issue was with a table I was merging into another. The key was a number, but in one of the tables, the service converted it to text. As a result, the merge returned only null values. When I performed operations on that merged column, the error occurred.
The strangest part is that, in the dataflow preview, the column appeared to merge correctly, making it seem like everything was working correctly. It wasn't until I created another dataflow referencing a pared-down version of the first one that the errors became visible in the preview. Thanks again for everyone reaching out!
Hi collinq,
Thanks for helping me out here. I’ll do some more digging into the data to see if I can find the issue.
One thing I find confusing is that the error message seems to suggest that a column with a numeric data type cannot contain null values. I always thought that was allowed. Am I misunderstanding something, or could this be an issue with how the data is being processed in the mashup?