Issue with relationships between 3 tables

[M4nS2211]

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

[M4nS2211 · Accepted solution]

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-...

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]

@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.

[M4nS2211]

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...