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!
Super UserHI data_4_good ,
This is one of those generic and common-ish messages. But, you may not have any errors in your queries. Desktop can handle these things becuase it basically ignores them but Service does not ignore these types of problems.
The issue is in a specific value in a specific column. So, i find this is commonly a Date type of field. The best way to find this is to slog through your data and find the date columns and then sort it ascending and descending to see if you have an abnormal field.
Also, the message clearly states that this is a number/null problem so do the same with any columns that you converted to a number. The issue could be something subtle - like a space and not a null, or a blank and not a null or a field that has a character in it.