Strange relationship

[geirselvag]

Hi folks,

I looking for best practise regarding creating relationship from DirectQuery model. Somehow the dim_tables doesn't create normal relationships (ref. image).

Can't find explaination or documenation of the reason for this type.

Appreicate assitance how to fix this.

[AlexisOlson · Accepted solution]

This indicates a limited relationship.

For more information, please see the documentation about such relationships here:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand

And read this article:

https://www.sqlbi.com/articles/strong-and-weak-relationships-in-power-bi/

[aj1973]

Hi @geirselvag 

That doesn't mean there an issue to fix. A composite relationship in other words a relationship between an import mode connection table to a DQ connection table(the one in blue) is represented that way.

[HotChilli]

It indicates a 'limited relationship'. Do you have a composite model?

There's documentation on the powerbi pages but it doesn't say anything about the diagram icon