I'm receiving this error with my query, and I can't understand why. I've checked some other topics for this issue, but haven't found a solution. In order to isolate the problem, I went from the end of my query and deleted every step until I found where the error was occuring, and it seems to be happening when I merge two queries together. This is where the problem happens:
If I delete the Table.ExpandTableColumn step, the error goes away. I've checked the columns in my raw data file, and there are no nulls there. I can't figure out what null it's trying to convert. Any help?