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

Narayana Swamy Chandaluri 1 Reputation point


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

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

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.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,763 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anonymous

    Power Bi is not currently supported here on Q&A. The product group for Power Bi actively monitors questions over at

    --please don't forget to upvote and 145510-image.png if the reply is helpful--

    0 comments No comments