Issue with related tables

[Anonymous]

Hello,

I'm trying to put data from the tables "orga" and "equipement" in a same visual table but it tells me that PowerBI can't find the relation between the two tables. In my data model (attached picture) the tables are related, so can anybody explain to me why I have this error ? 

Regards,

JM

[v-yanjiang-msft]

Hi @Anonymous ,

According to your description, I create a sample, in your data model, it's hard to filter from many side to one side across many tables. I modify the model to many to many during the filter transfer, it can work fine.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Make Oga and Transco bi-direction and check

[Anonymous]

Thanks for your answer, I tried your solution but the problem is still there :'( I found a workaround by putting a measure (like number of rows in the table "equipement") and hidding it (resize). But I still don't understand why PowerBI can't make the relation whitout that