Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
Solved! Go to 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.
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.
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 35 | |
| 34 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 136 | |
| 102 | |
| 68 | |
| 66 | |
| 58 |