Forum Discussion

Whatever2's avatar
Whatever2
Helper I
8 years ago
Solved

relationship unique value

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 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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