cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ilcaa72 Member
Member

How to make a relationship, no distinct columns

hello,

 

i have 2 tables.  Table 1 = 764 rows, Table2=9384 rows.

 

i keep getting error messages saying " relationship cannot be created, because 1 of the columns must have unqiue values"  through 1 does have have unique values...

 

any otpions?  thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Moscuba Member
Member

Re: How to make a relationship, no distinct columns

If there is even one of the values repeated it is not Unique.

 

Manually set the relkationship:

Go to the Schema View 

Click on Manage Relationships

Select the table with Many data points (top section), highlight the column to link

Select the table  with unique values (bottom Section), highlight the column to link

Cardinality: Many to one

Cross Filter direction: Single

 

If that doesn't work you may have to make a table to go between them that has nothing in it but the unique values. 

2 REPLIES 2
Highlighted
Moscuba Member
Member

Re: How to make a relationship, no distinct columns

If there is even one of the values repeated it is not Unique.

 

Manually set the relkationship:

Go to the Schema View 

Click on Manage Relationships

Select the table with Many data points (top section), highlight the column to link

Select the table  with unique values (bottom Section), highlight the column to link

Cardinality: Many to one

Cross Filter direction: Single

 

If that doesn't work you may have to make a table to go between them that has nothing in it but the unique values. 

VSchepens Regular Visitor
Regular Visitor

Re: How to make a relationship, no distinct columns

Hi @ilcaa72,

 

Your table with unique values must not include a blank row.

Can you check whether this is the case?

 

If you create a table with twice the key in the columns, once as text and once as count, you can check whether certain values appear twice or if your table includes blank rows.

 

Regards,

 

Valérie

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 318 members 3,237 guests
Please welcome our newest community members: