Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Issue with related tables

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

 

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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 

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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.