Manuel Garcia Prieto on 30 Sep 2022 08:01:43
When you are in a "Limited Relationship" the result when using fields from both tables is "INNER JOIN" like. This is explained here https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand#relationship-evaluation
It took me a long time to find why I wasn't getting the LEFT OUTER JOIN results I was expecting. This is a fundamental behavior difference and the reasons are very hidden in that help page.
In my opinion the Power BI desktop tool has all the information required to show a warning message when the relationship is being created (knows the cardinality and knows the source group type of each table). Can a warning message be added when you are creating this type of relationship that it will behave with INNER JOIN semantics?