I get the error "An error occurred while communicating with the data source all inputs to union must have matching column types" when running my flow. I was using it without problems all 2024, but now I modified it because I had a date filter (show only 2024) that I needed to update. I even rolled back my filter but keep getting the error. Talked to the DB administrator and he says they haven´t made any changes to sources (variable names, columns, DB types). Is it a known error? Please help.
PS: I get the error in desktop and in web.
3 answers
For me it was that one of my tables in the union had a spatial column and the other one didn't. Once I removed the spatial column it worked.