cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dhruvin Member
Member

Row 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.

Screenshot_1.png

 

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

 

Here is how I implemented RLS.

Screenshot_3.png

Screenshot_2.png

 

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dhruvin Member
Member

Re: Row Level Security not Work for Multiple Tables in Power BI

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.

 

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Row Level Security not Work for Multiple Tables in Power BI

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.

 

real.PNG

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Highlighted
Dhruvin Member
Member

Re: Row Level Security not Work for Multiple Tables in Power BI

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.

 

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors