Forum Discussion
Solved
Relationships
Hi Iam trying to create relation between two table with Company Name as the Primary Key , even though my Company table has unqie records Power Bi through up an error saying You can't create a relationship between these two columns because one of the columns must have unique values"
can someone pls point out my mistake , here are table i am having an issue with
https://1drv.ms/x/s!AoFOemM4aW7PtccTFex-8sA1WnEujA
Look the duplicate record in companies table
6 Replies
Check is there aby blank value in Comapny Name column .
if yes that is the problem. if not am sure u have duplicate in your comapny name column 100 %
