Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Error Unable to Load Visual: Join Paths are expected to Form a Tree. Two Join Paths To Table

Hi 

 

I am now getting the above error since updating PowerBI Desktop and it won't load a visual which seemed to work fine before. 

 

I have one active relationship joining the table and 2 inactive relationships joining elsewhere in the table so I can use Userrelationship to easier calculate using DAX. 

 

Context: I've joined a staff table joined to an operation table where it's possible the staff member will have one of a possible 3 roles within a row of data. i.e Staff 1, Staff 2, Staff 3. 

 

Any suggestions / ideas? 

 

Thanks 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Anonymous

     

    Thanks for the suggestions. 

     

    I selected more than one filter in more than one table for the RLS which seemed to clash.

     

    I fixed it by just creating a dynamic table and using one filter for the RLS. 

11 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    To add to this I think it may be since I've applied row-level security??

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Anonymous,

     

    Since I can’t reproduce your issue, can you provide a sample to reproduce your issue?

     

    In addition, you can try below methods to ensure which part the issue appeared:

     

    1. Check if the issue is related to visual.

    Try to use old table to create a new visual and check if the issue appeared again.

     

    2. Check if the issue is related to Row-Level Security.

    Try to delete the old Row-level security, then build a new one to test if the issue appeared.

     

    3. Check if the issue is related to the relationship.

    Remove the relationships and re-create the relationship and test again.

     

    If above is not help, please share some detail information about your issue.

     

    Regards,

    Xiaoxin Sheng

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Anonymous

       

      Thanks for the suggestions. 

       

      I selected more than one filter in more than one table for the RLS which seemed to clash.

       

      I fixed it by just creating a dynamic table and using one filter for the RLS. 

      • mariograffe's avatar
        mariograffe
        New Member
        9 years ago

        Hi MG83, could you give me some details about your dynamic table to solve the problem ??

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I had the same issue. The problem was in bi-directed connection for one pair of tables in the model (Both instead of Single). After fixing the problem has been resolved.