Forum Discussion
Solved
Unfamiliar icon on relationship lines in Model View
One of my clients encountered this the other day, and I confess I've never seen this before. When they create a relationship between a DirectQuery table and an Imported table, they're getting a funny...
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
Speaking for myself, my scenario is that when I add additional data source to an existing dataset with one of the queries that is over 1 million lines, the relationship would not work completely, it's over the capacity.