Forum Discussion
Solved
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 ...
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/
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.