Forum Discussion
Issue with relationships between 3 tables
Hello,
I have an issue with relationships between 3 tables (Table 1 > *---1 > Table 2 > 1---* > Table 3)
When I combine Table 1 & Table 2 or Table 2 & Table 3 in a visuel it works but I can't add fields from Table 1 & Table 2 & Table 3 in the same visual.
My Key (Id_Espece) is well unique in Table 2. I try it in SQL and it works perfectly.
Give me headache.... Do you have any suggestion for me, to retrieve some hope ? Please help 😄 Thanks
Seems to be the same issue than this topic : https://community.powerbi.com/t5/Issues/Problem-aggregating-across-many-to-many-link-table-in-Power-BI/idc-p/353921#M21787
Current limitation in Power BI... So I add a measure (count distinct on my Key) on the Table 1 and I will add it each time I need to have a visual with fields from my 3 tables. Very ugly but I need it now ! Hope it'll be resolved in nexts updates...
3 Replies
Seems to be the same issue than this topic : https://community.powerbi.com/t5/Issues/Problem-aggregating-across-many-to-many-link-table-in-Power-BI/idc-p/353921#M21787
Current limitation in Power BI... So I add a measure (count distinct on my Key) on the Table 1 and I will add it each time I need to have a visual with fields from my 3 tables. Very ugly but I need it now ! Hope it'll be resolved in nexts updates...
- amitchandak
Super User
M4nS2211 , You can not have ungrouped columns/not summarized from both Table1/Table3 (Many side). Use aggregation like min/max on any one of the table columns, that should work.
Thanks amitchandak ! It works fine. But I'm not satisfied by this behavior. Do you understand why we need to do that ? In SQL I dont' have to summarize any columns to have the good results.
The dataset is for non technical users and the understanding of this manipulation will not be easy...
