Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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 %
@BaskarI have created a Pviot Table to count the occernace of a vaule and there are only unquie values in my loookup table , with no blank spaces , You can look at the attached link , I am not able figure out where iam going wrong
Look this machi , u have dupilcate in country
But I am just looking up the company Name , Is it required that every cloumn in my lookup table shoud be unquie ?
Look the duplicate record in companies table
Thanks Baskar ! Now i look every silly I spent an hour going throught it and i missied !
Appricate your help 🙂
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
71 |