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 connection.

But i am sure that table only with unique fields. Can you help me what is problem?

Thanks

Need Help

3 Replies

  • 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.

       

       

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi sevastr ,

     

    Please share us your .pbix file, removing real data and sensitive information. 

    It is suggested to upload your file to OneDrive for Business and then paste the link here.

     

     

    Best Regards,

    Icey