Forum Discussion

nlevin's avatar
nlevin
Frequent Visitor
10 years ago
Solved

inactive relationship

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?
Need Help
  • Rémi's avatar
    Rémi
    10 years ago

    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.

     

     

Alex_J_Potter's avatar
Alex_J_Potter
Advocate I
10 years ago

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.