Reply
Frequent Visitor
Posts: 12
Registered: ‎10-10-2017
Accepted Solution

"Your cant create a relationship

Hi team, 

Objective:

I would like to have a graph / table showing:

- cardboard collected & cardboard verified

 

When i try and create a relationship, i receive an error. Please see below.

- The "Value" in Card collected  table and "tonnage" in Card verified are unique.

 

Thanks in advance.

 

Relationships.png


Accepted Solutions
Highlighted
Super User
Posts: 2,142
Registered: ‎09-19-2016

Re: "Your cant create a relationship

Hi @jhaldane,

PBI by default make 1 to many relationships and this is the error given when you are trying to make a many to many relationship you can select the cardinality to have the many to many.

However as a good practice and to simplify the model the best way is to create a date table with unique values and relate that table with your two tables.

Regards,
MFelix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post


All Replies
Highlighted
Super User
Posts: 2,142
Registered: ‎09-19-2016

Re: "Your cant create a relationship

Hi @jhaldane,

PBI by default make 1 to many relationships and this is the error given when you are trying to make a many to many relationship you can select the cardinality to have the many to many.

However as a good practice and to simplify the model the best way is to create a date table with unique values and relate that table with your two tables.

Regards,
MFelix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!