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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

RLS on Dim table and not Fact?

Hi,

 

I have a model with around 20 tables, (18 of them Dim and 2 facts...)

 

I want apply dynamic RLS.

 

I wanted to apply the filter on a DimCostumer, like this:

 

=[SK_Cust] IN
SELECTCOLUMNS(
FILTER(
'Responsible'
,'Responsible'[NTUserName] = USERNAME()
)
,"Cust"
,'Responsible'[DW_Cust]
)

 

and then it be propagated to the rest of the tables (both fact tables...) is this doable/best practice? Or do I have to set RLS on each Fact. (I have SK_Cust on both fact tables...)

 

2 REPLIES 2
Anonymous
Not applicable

Hi @Anonymous ,

How does your data model look like? Whether the relationship be created among the dimension tables and fact tables base on specific field(for example:SK_Cust field)? The following links are the ones for creating dynamic RLS examples, hope they can help you.

What Do You Need to Implement Dynamic Row-Level Security in Power BI?

Configuring “all” access with dynamic row-level security

DAX Code for Dynamic RLS

Best Regards

amitchandak
Super User
Super User

@Anonymous , Doing on dimension is a better way. As using one dimension you can control more than one fact

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors