Forum Discussion

sevastr's avatar
sevastr
New Member
6 years ago

Problem with relationship

Hi I create table with Unique Value in Power Query Editor (made Table.Distinct) Then i tryed to create relationship with source table but power bi tells me that there is error with many-to-many con...
Need Help
speedramps's avatar
speedramps
Super User
6 years ago

Hi sevast

 

If you read the message very careful I think it is says only use many-to-many is the table key is not unique 

 

In the relationship dialogue box try change the default cardality from many-to-many to one-to-many.

 

Please leave kudos if this soution works, thank you.

 

 Good luck!

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    Try the bridge table. Let's say you have two tables i.e. Table A and Table B.

    Create a new table via desktop:

    key Table= Distinct(Table[Your Key Column])

    Then join the Table A with Key Table and then Table B with Key Table.