Forum Discussion

shaherbano's avatar
shaherbano
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Cardinality Error

Hi, i am not able to connect the 3 tables i have.  gettign the following error:  failed to save modifications to the server. Error returned: 'Relationship 'd1259967-03f1a-b4a5-f83344f5d47'..." betwe...
Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
8 years ago

it seems you try to set up Many to Many relationship, Power BI supports One to Many & One to One relationships

shaherbano's avatar
shaherbano
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

My bridge table has primary unique key which is connecting to corresponding keys in 2 seperate tables. there are certain rows on both tables with distinct values (in one but not on other). My goal is to compare the fields of one table to those on the other. 

then create a result column that calls out; which cell values are not a match.