Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Can't determine relationship between fields

I have three tables as in the following photo.

Invoices.SKU joined to SKU_ID_mapping.ID

SKU_ID_mapping.SKU joined to product categories.SKU.

 

In the past it worked but this time I am getting an error that PBI cannot determine relationships. I am taking date from invoices and category from product_category lookup.

 

What am I doing wrong with this? 

Help please - I am out of wits with thiserror I am getting

 

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Please try not to use bidirectional connections from a dimension to a fact table.

     

    Add a measure to your visual, any measure.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi lbendlin thanks, why bidirectional connections are not a good idea? 

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        Let's say you have RLS on the dimension table.  With the bidirectional connection that RLS becomes ineffective.