Row Level security for multiple tables not working as expected

[Apoorva1]

I have a requirement to apply RLS in my Agile dashboard which is created on Dataverse tables. I have 3 tables- Stories, Defects & Enhancements. I also have Business Units for 4 teams- MS team, Sales team, Manager team, Client team. The Hierarchy is- MS team & Sales team are independent of each other and fall under Manager team. Under MS team, we have Client team. All of these teams have their own Business units and BUs also follow the same Hierarchy. I want to implement RLS in such a way that Manager team can see everything unfiltered. Sales team can see only their BUs data. MS team can see their BUs data and Client teams BUs data. Client team only sees their BUs data. 

I created the following roles- 

For Client I applied same filters on the following tables- 

For Sales, I applied same filters on the following tables- 

For Managers I did not apply any filter.

For MS I applied same filters on the following tables- 

As these are the names of my Business units.

I am trying to get correct results but on applying these conditions, My dashboard shows empty charts.

Kindly help

[DataVitalizer]

In this case could you share a screenshot of you data model? This would help investigating the issue.

Did it work ? 👍 A kudos would be appreciated ‌‌📢 Mark it as a solution to help spreading knowledge

[Apoorva1]

Sure! 

[DataVitalizer]

The data displayed in your charts is brought from which table(s)?

Did it work ? 👍 A kudos would be appreciated ‌‌📢 Mark it as a solution to help spreading knowledge

[Apoorva1]

I have 4 pages in my report. 1 is Home page that is using data from Defect, Stories, Sprint. 2nd page is my Stories Page that uses data from Stories table. 3rd is Defects page, that is using data from Defect and Change Request table. 4th page is Enhancements page that is using data from Enhancemrnts table.

Page1-

Page2-

Page3-

Page4-

[DataVitalizer]

Hi @Apoorva1 

Try changing the cross filter direction of both relations of 'Stories' table to both.

Did it work ? 👍 A kudos would be appreciated ‌‌📢 Mark it as a solution to help spreading knowledge

[DataVitalizer]

Hi @Apoorva1 
Have you added your users to the appropriate groups in Powe BI service?

Did it work ? 👍 A kudos would be appreciated ‌‌📢 Mark it as a solution to help spreading knowledge

[Apoorva1]

I am using the View As option to verify the roles data in Power BI desktop.