Why does Query Source Data not show duplicate rows?

Answer:
Query Source Data does not return all rows when querying a table with case sensitive primary key. The underlying data structure is a .NET DataTable, which has support for adding/updating based on PK. The data table ignores case, and updates “duplicate” rows in place, instead of showing two rows with different casing.