More Distinct/Unique values than rows in table

I'm still having this issue. I feel I should mention that this is a showstopper for me as this issue prevents me from using this ID column as a foreign key in another table. When this issue pops up PowerBI insists that I must have many-to-many relationship. This happens when my tables are in DirectQuery mode. If I convert them into Import mode, the relationship problem seems to go away. However, as I mentioned in my initial post, I require these tables to be DirectQuery.

I would appreciate it very much if someone official could respond to this to at least let me know if this is a bug or a dumb-user-error. So that I can adjust my requirements/plans going forward.