Underlying Query property
If you change the underlying query to something like the following, you must also set the Oracle ROWID property to No:
SELECT DISTINCT <non-key column>
Otherwise the DISTINCT clause will apply to the (implicitly used) ROWID instead of the non-key column. The "same" data might then appear to be displayed more than once.