Forum Discussion
geirselvag
4 years agoFrequent Visitor
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 ...
- 4 years ago
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/
HotChilli
4 years agoCommunity Champion
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