Forum Discussion
RLS using an inactive relationship
jsteckel ,
Could you build a one-many relationship between Sales table and Customers Table? For example, add index columns or some other flags column in the two tables and build a relationship:
SalesTable[Flag] --> * CustomerTable[Flag]
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yuta-msft,
Thank you for the idea. I do have 2 relationships between SalesTable and CustomersTable. They are:
Active: SalesTable[AccountNumber] = CustomerTable[AccountNumber]
Inactive: SalesTable[SalesPerson] = CustomerTable[SalesPerson]
It did work for the CustomerContact table to make the SalesPerson link active, unfortunately, it breaks other financial matrices in the reports. They are more important, so I will have to leave those relationships as they are.
Perhaps I will have to make a seperate dataset\report and make the correct links active to work with Row Level Security.