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!
Thank you collinq, rohit1991, and v-kpoloju-msft for contributing to the conversation. I went in and did find a replace null for 0 on all columns and am still receiving the same error. I am not sure what is going on...
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!