RLS in a composite Data Model with two different datasets connected

Hi,

Hi everyone,

I've got 2 separate datasets connected via directquery: Stock Actual and Sales.

On the datasets via directquery there is no RLS.

In both datasets the column on which I would like to implement the RLS exists and it's called store_code.

Then, I've imported the table store_md (import mode) which contains info and dimensions on the granularity: store_code.

I connected the three tables on the column store_code.

I've tried to create roles on the store_masterdata but it doesn't work on service:

the store masterdata has been correctly filtered but the tables via directquery not.

Any idea what can be done here?

Thanks in advance.