relationship unique value

[Whatever2]

hello everyone 

I'm trying to create a table that contains 2 related ID but when i try to link it to my other table i get this message :

 

does anyone know how to tell Power bi it's okay not to have unique values ?

thanks in advance 

[Anonymous · Accepted solution]

Hi @Whatever2,

Unfortunately Power BI requires you to have one of the tables in the relationship to have a unique column. If you have access to Query Editor, you can remove duplicate value; otherwise you can refer to this post to combine quote_no values from the two tables, and use it to connect your tables via quote_no