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

Narayana Swamy Chandaluri 1 Reputation point
2022-11-30T12:31:38.027+00:00

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.

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
    2022-11-30T13:37:16.877+00:00

    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 145510-image.png if the reply is helpful--

    0 comments No comments