Forum Discussion
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...
it seems you try to set up Many to Many relationship, Power BI supports One to Many & One to One relationships
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.
But doesn't Power BI give an explicit message when you try to do that? This must be something else.
well it did give the error - could it be that the in desktop version it's 1 to many, while in the service dataset is bigger and it becomes many to many?
