Forum Discussion

kkanda's avatar
kkanda
Resolver II
1 year ago
Solved

Unable to create relationship between tables

Hello All, This is not a  new problem. When I tried to link two columns of different tables in the Relationship pane, I keep getting the message that one table column must have unique values. I foun...
Need Help
  • kkanda's avatar
    kkanda
    1 year ago

    Hello All, 

    Thank you for your responses to solve my problem. Finally, I found that out of 278K cells, less than 20 cells have text including "?". I removed these rows and I was able to create the relationship. 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi kkanda 

 

Try the following steps to solve the problem:

1. Use the TRIM() function to ensure that there are no leading or trailing spaces. 

2. Use the COUNTROW() function to create a calculated column to count the number of times each value occurs, to see if there are any values greater than 1.

3. If appropriate, consider creating a composite key by combining this column with another unique value column.

 

Refer to: Tips and tricks for creating relationships in Power BI Desktop 

 

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.