Datasets that have more distinct values than ONE DATA is allowed to calculate (based on the distinct values limit) lead to wrong calculation of the SyncSets. As a result, tables which are based on such datasets and connected with SyncSets will not produce expected results.

 

In this case, one has to use server-side filtering based on Postgres data sources, see Optimizing performance with server-side filtering .