cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Apoorva1
Regular Visitor

Row Level security for multiple tables not working as expected

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- 

Apoorva1_0-1700553638099.png

 

For Client I applied same filters on the following tables- 

Apoorva1_1-1700553868936.png

 

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

Apoorva1_2-1700553911244.png

 

For Managers I did not apply any filter.

For MS I applied same filters on the following tables- 

Apoorva1_3-1700554065147.png

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

7 REPLIES 7
DataVitalizer
Super User
Super User

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

Sure! 

Apoorva1_0-1700559941103.png

 

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

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-

Apoorva1_6-1700629243901.png

 

Page2-

Apoorva1_3-1700629162241.png

 

Page3-

Apoorva1_4-1700629180645.png

 

Page4-

Apoorva1_5-1700629223150.png

 

 

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
Super User
Super User

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

 

 

 

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

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors