Forum Discussion

shaherbano's avatar
shaherbano
Microsoft 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
Community 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

gvg's avatar
gvg
Post 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
    Community 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?