Forum Discussion
Strange relationship
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.
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/
3 Replies
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
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.
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/
