Forum Discussion
Unfamiliar icon on relationship lines in Model View
This indicates a limited relationship.
The Microsoft Documentation describes it here:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand#limited-relationshipsIt's also worth checking out Alberto Ferarri's article here:
https://www.sqlbi.com/articles/strong-and-weak-relationships-in-power-bi/Prior post:
https://community.powerbi.com/t5/Desktop/Strange-relationship/m-p/2199738
Super UserThis indicates a limited relationship.
The Microsoft Documentation describes it here:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand#limited-relationships
It's also worth checking out Alberto Ferarri's article here:
https://www.sqlbi.com/articles/strong-and-weak-relationships-in-power-bi/
Prior post:
https://community.powerbi.com/t5/Desktop/Strange-relationship/m-p/2199738
AlexisOlson, thanks so much for replying! I have a question about this, though: when I first saw this example, that was the exact thought I had -- that it represented a limited relationship. But, I haven't been able to find any documentation that mentions this visual representation, nor have I been able to reproduce the effect by adding a limited relationship to a model using the most recent build of Power BI Desktop. Do you know when this functionality was added? Does anything else need to be true for it to appear in the Model View?
Thanks again!
- AlexisOlson
I think it's fairly recent (within the last 6 months?).
I learned about it from the Mastering Tabular video course by the SQLBI guys. The 'Limited relationships' video is apparently one of the free preview videos in this course, so you may want to check it out. I don't know more about it than they cover or what can be gleaned from the other links I provided.
They do not really give much content for FREE.. Only the outline and sales pitch. Bare bones. Outline is very strategic and impressive though 😉