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.

     

     

Rémi's avatar
Rémi
Icon for Resolver III rankResolver III
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.