Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
stkarthik
New Member

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

 

 

1 ACCEPTED SOLUTION

Look the duplicate record in companies table 

1.JPG

 

 

 

 

View solution in original post

6 REPLIES 6
Baskar
Resident Rockstar
Resident Rockstar

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

1.JPG

 

 

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 

1.JPG

 

 

 

 

Thanks Baskar ! Now i look every silly Smiley Embarassed I spent an hour going throught it and i missied !

Appricate your help 🙂

 

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.