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.

  • gvg's avatar
    gvg
    Icon for Post Prodigy rankPost Prodigy
    8 years ago

    Stachu,

     

    But doesn't Power BI give an explicit message when you try to do that? This must be something else. 

    • Stachu's avatar
      Stachu
      Icon for Community Champion rankCommunity Champion
      8 years ago

      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?