Row Level Security not Work for Multiple Tables in Power BI

[Dhruvin]

Problem:

I developed a report using 5 to 7 tables. I want to apply RLS. When I pass customer Id they can view only their data.

The report have different slicers like - Carriers and Clients. Based on CustomerId the values should be filtered.

The slicers are working properly. But when I apply RLS with same applied Join its not work.

Description:

Tables:

• WayBills
• Invoices
• TplClient
• Carriers
• Customer
• CustomerCarrier

Below is a diagram of relationship which I have applied.

Here is a link to Download the PBIX file - PBIX FILE DOWNLOAD

Here is how I implemented RLS.

Please help me if I'm doing wrong anything here.

[Dhruvin · Accepted solution]

To resolve this issue, I changed the relationship between the tables.

RLS not apply properly if the relationship has not been established properly.

To resolve this issue, I used some DAX expression to take value of Customer Carriers to Carrier table.

I reduced the dependancy of the other tables to get name and all.

[v-frfei-msft]

Hi @Dhruvin,

You will need to apply the tick next to “Apply security filter in both directions”. Please check the steps by the online document.

Regards,

Frank