inactive relationship

[nlevin]

Is anyone having issues where Power BI is not allowing a relationship between two tables because it says a relationship already exists, even when there is no existing relationship?

[Alex_J_Potter]

It usually has to do with Power BI automatically creating the relationships after data load in my experience.  Check to see if relationships that should be "Many to One" have instead been auto-set to "Many to Many" or "One to One" under the Advanced Options for the relationship. 

I usually set my Power BI workbook to NOT "Autodetect new relationships after data is loaded" before I load any data to avoid this. 

[Rémi · Accepted solution]

Hi,

It's not a problem from Power BI but from your data model :

For example :

I have 3 tables called Country, cities and People. I create a relation People to cities and cities to Country. Then you will have this alert if you want to create a relation People to country.

It said "there is an existing relation ship" because we can have the country of a people by regarding the city.

It's the same thing for you, you have ever a relation though an other table.