Need to know cause for many to many relationship even with unique values in power bi

Question

Hi,

I have 2 tables for which I need to setup many (table 1) to one (table 2) relationship in power bi

Context:
The 2 tables have multiple duplicates with no unique columns. So, I have created a "key" column through concatinating a few indicator columns.

Issue:
I know for a fact that table 1 has duplicates even in "Key" column I have created but there are only unique values in table 2, Even now I am getting Many to many relationships which I try to apply relationship to both.

Any thoughts on why this is happening.

Answer 1

Power Bi is not currently supported here on Q&A. The product group for Power Bi actively monitors questions over at
https://community.powerbi.com/

--please don't forget to upvote and if the reply is helpful--