The icons between tables in relationship

[AdeleSS]

Hi All,

I created relationships with two date table and the lines between them seems broken. What does this icon mean?  Many thanks.

[Idrissshatila · Accepted solution]

Hello @AdeleSS ,

check this solution https://community.fabric.microsoft.com/t5/Desktop/What-do-broken-relationship-lines-in-datamodel-mea...

[jolind1996 · Accepted solution]

Hi,

I found this relating answer from 2021: Solved: What do broken relationship lines in datamodel mea... - Microsoft Fabric Community

In Power BI, a "weak" relationship, now referred to as a "limited" relationship, is a type of relationship where Power BI cannot guarantee the cardinality on the "one" side.

This situation can occur when the engine cannot ensure the unqueness of the constraint due to technical reasons, or because the developer defined it as such. A limited relationship is not used as a part of table expansion.

Limited relationships were introduced in Power BI with composited models in 2018. Even though they look like regular relationships, they hide some complexities.

You can still utilize the relationship by using specific DAX functions like USERELATIONSHIP to override the default active relationshp. This allows you to control which relationship to use in your calculations.

Best regards,
Johannes

[Idrissshatila · Accepted solution]

Hello @AdeleSS ,

check this solution https://community.fabric.microsoft.com/t5/Desktop/What-do-broken-relationship-lines-in-datamodel-mea...

[jolind1996]

Hi, AdeleSS

The broken lines between the tables in your data model indicate inactive relationships. These relationships are not used in the current context but can be activated as needed. You can use the USERELATIONSHIP function in DAX to specify which relationship to use in a calculation, overriding the active relationship. Power BI allows one active relationship and multiple inactive relationships between two tables.

Best regards,

Johannes

[AdeleSS]

Thank you for your pormpt reply.

But you can see in my picture, it's not dotted line but a solid line broken twice with parentheses. I haven't find this situation in training material.

And here is picture that shows the link is active now: