Problem with relationship

[sevastr]

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

[Icey]

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

[speedramps]

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]

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.