I'm using an agent. Why are my joins not working?

All datasources that belong to a particular join need to be on the same agent for the join to work. If you have data on a private agent but also have data on the hosted agent then the join across both will not work.

You will need to ensure that all your datasources use the same agent.