Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |