Can't determine relationship between fields

[Anonymous]

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

[lbendlin]

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

Add a measure to your visual, any measure.

[Anonymous]

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

[lbendlin]

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