Forum Discussion
Helper IIIRow Level Security not Work for Multiple Tables in Power BI
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.
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.
2 Replies
v-frfei-msftCommunity Support
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
DhruvinTo 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.
