Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

View all the Fabric Data Days sessions on demand. View schedule

Reply
Anonymous
Not applicable

Why is the ‘row level security’ grayed out? Will the RLS work?

I have a RLS requirement, where I need:

  • The user accessing the report to see only her/his own data.
  • Teamleads can read their own data + their teams.

 

 

In the USER role, I have the RLS:

Users table  =[NT Username] = USERNAME()

 

 

 

In the Team Leads role, I have the RLS:

Users table = [TeamLeadUserId] IN SELECTCOLUMNS(FILTER('Users' ,  'Users'[NT UserName] = USERNAME() )

                           ,"Id"

                           ,[User Number])

 

 

In my model I have 2 facts, a classic one, and an AggregatedFact.

 

In my model I have the classic: “1 to MANY” User dimension to Fact.

 

Then I have a “Many To Many” User dimension to AgProfitCenter dimension

ovonel_0-1673987923458.png

 

 

 

Why is the ‘row level security’ grayed out? Will the RLS filter the AgProfitCenter table?

 

 

Lastly, I don’t understand why if in the details it is clearly marked as *:*  in the Manage page it appears as *:1

 

 

ovonel_1-1673987950926.png

 

 

 

 

Note:  dimension AgProfitCenter connects to AggregatedFact; which holds aggregated data.

 

 

0 REPLIES 0

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.