cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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

 

 

 

 

View solution in original post

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
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors