Regarding there is no defined relationship defined yet message while managing relationship

[Kiruthiga]

Hello Team,

Appreciate your time!! Below is my data model relation should be with my 3 tables 

Table1 --->Table2

Table1---->Table3

Table1 has duplications but Table2 and Table3 dont.

For eg:

Table1

Key1,Key2

A1,A2

Table2:

Key1

A1

B1

C1

Table2:

Key2

A2

B2

C2

I tried connect from Table1 to Table2 as 1 to many relationship with one side like wise the same idea with the Table3 from Table 1 however its rendering "there is no defined relationship defined yet " after I create a new relationship

Please suggest!!

thank you!

Best,

Kiruthiga

[v-saisrao-msft]

Hi @Kiruthiga,

We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.

Thank you.

[rohit1991]

Hi @Kiruthiga,

The “no defined relationship defined yet” message is almost always because Power BI needs the “one” side of a one-to-many relationship (in your case, Table2 and Table3) to have unique keys. Since Table1 has duplicates in Key1/Key2, you can’t link directly—Power BI will stop you.

Here’s what usually works best in this scenario:

1. Create a bridge table with all unique Key1 and Key2 combinations. You can easily do this in Power Query: Select just the Key1 and Key2 columns from Table1. Remove duplicates. Name it “BridgeTable”.
   
   

2. Set up relationships so BridgeTable connects to Table1 (many-to-one) and to Table2/Table3 (one-to-one or many-to-one, depending on their data). The BridgeTable should act as your slicer/filter in visuals.

3. Build your report visuals and filters using the BridgeTable. This way, everything filters and aggregates properly, and you avoid the “no defined relationship” issue.
   
   

Why use a bridge table? It keeps your data model clean, allows for proper relationships, and gives you more control if you add more tables in the future. It’s the standard approach in Power BI for handling these cases.  Avoid using many-to-many relationships unless you’re absolutely sure you need them , they can create unexpected results.

[Kiruthiga]

Thank you Rohit! I am planning to create a brdige table between Table1 and Table2. This table will have only distinct keys then a connection from bridgetable to table1(one to many) and bridgetable to table2(one to one) is the idea? (likewise another bridge from table1 to table3)

If I do that since my filters are in table1 , will still that works? 

appreciate your thoughts!

Best,

Kiruthiga

[v-saisrao-msft]

Hi @Kiruthiga,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-saisrao-msft]

Hi @Kiruthiga,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-saisrao-msft · Accepted solution]

Hi  @Kiruthiga,
Thank you for reaching out to the Microsoft Fabric Forum Community. 

Thank you @rohit1991 @lbendlin, for your helpful insights.

To address the "no defined relationship" issue, creating bridge tables is an effective approach. Since Table1 contains duplicate keys (due to the granularity of Brand, PG, and Segment), it cannot be used directly in a one-to-many relationship with Table2 and Table3, which have unique keys.  

While this approach is effective, there are some limitations you should be aware of:  

• Adding bridge tables increases the complexity of your data model. You'll need to manage additional relationships, which could become harder to maintain as your model grows.  
• The added relationships and more complex DAX queries could lead to slower performance, especially with large datasets.  
• If relationships aren't correctly configured, it may lead to issues with filter propagation, causing inaccurate data. Ensure all relationships are set up properly and use DAX functions like USERELATIONSHIP if needed.  
• Ensure your bridge tables contain only distinct values. If duplicates are present, it could impact the accuracy of your results.  
• Be cautious of introducing many-to-many relationships, as they require careful management and may necessitate advanced DAX for correct behavior.  

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you 

[Kiruthiga]

Sure I agree. Technically its a Scoresheet we are converting from Qlik to PowerBI. Table 1 has dimension and Metrics. Table2 and Table 3 only have metrics. Basically the Vendor's Brand,PG,Segment info in Table1, only PG info in Table2 and only Segment info in Table3. Since PG is level1,Segment is Level2 and Brand is level3, we have duplicates for PG and Segment in Table1 since it has more  more granular level. however PG and Segment tables only have their entires once., The report should load the PG(table2) and Segment(table3) for the PG's and Segments exists in Table1 . The PG total(tbl2)  and Segment total(tbl3)  should reduce based on the filters (PG and Segment from table1)

Appreciate your thoughts!

Thank you!

Best,

Kiruthiga

[lbendlin]

Read about normalizing and pick a NF that will work for your scenario.

[lbendlin]

Table1 has duplications but Table2 and Table3 dont.

Then Table1 should not control Table2.

Read about the idea of dimension tables (things you filter by)  and fact tables (things you calculate).  Dimensions ideally don't have duplicates. Dimensions control facts, ideally in a 1:* single direction relationship.

Search for "Star Schema".