Forum Discussion
Data Modeling: Relationship Error while fetching data from 3 tables
Hello Power BI Community, I am trying to fetch data from three different tables which are connected in my Data Model but the relationship error gets thrown. The screenshot below explains the data ...
Thank you for providing relevant material to this problem, Daniel.
For the issues discussed in the attached links, I see that there is a bi-directional relationship on either side of the two tables, whereas in my case, there is only one bidirectional relationship with the occupation table while the occupation table is single directional towards the occupation geo bridge table.
Still finding it difficult to understand why the relationship would break in this case since there isn't bidirectional on both sides of the Table B, it exists only between Table A and Table B.
ok so,
when you dont add any measure or summarized column in the visual, what power bi does internally is that it adds a hidden calculation, which is (
CALCULATE(COUNTROWS('table_from_the_many_side')) of the relationshipalthough you cant tell what is happening, im assuming, because you have 2 tables on the many side of the relationship,and you are using them in the table as dont summarize, power bi is trying to create that internal hidden measure ( since you didnt add a measure into the visual ) , but since the 2 tables,which are , rls cust and occupation geo are not linked , ( by that i mean that occupation geo cant filter rls cust details or relate to it in any way ) ,that is why the problem occurs.now you can change the second relationship to bi-directional, and still the error will still occurs,but here, i dont think it is worth to dig deeper, cz no one wants to create a model with random and multiple bi-directional filters which in this case, the model would be complex and hard to understand the result you are getting in the visuals , especially when you start authoring some complex dax code.hope this helps.