When running a flow with multiple connections and a union that also has an aggregate step, the following error may occur:
System error: An error occurred while communicating with the data source. No such column.
The issue does not occur on Tableau Prep Builder versions earlier than 2023.3 and the same flow previously worked on an earlier version if you recently upgraded.
The same error can occur on flows published to Tableau Cloud.