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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
JRA21_13_19_25
Frequent Visitor

Dynamic RLS and Apps Permissions List

Hello,

 

I want to use a security table to create dynamic RLS using USERPRINCIPALNAME() so that employees can only view data for their region.

 

If an employee is the security table but they are labelled under a region that is not in my report, will they be able to view all the data in the report if I still add their email address to the permissions list in my App?

 

Many Thanks,

 

1 ACCEPTED SOLUTION
Vera_Carey
Frequent Visitor

RLS utilizes filters to restrict data access (usually based on roles). If your filter result returns no rows, as would be when an employee is labeled under a region that is not in your data, that employee will see exactly that - nothing.

 

Here is a quick theoretical example. Let’s say your filter DAX look like this:

     [SalesRegion]=”Value”

If your employee in question is assigned to “Europe” the RLS filter will return the following result:

     SalesRegion=”Europe”

…and if “Europe” is not in your underlaying data, then that filter will return no rows (and that is exactly what this employee will see (no rows/nothing).

 

Quick note - You can check if your role/RLS is acting as expected in Power BI Service. To do that, in Power BI Service, select More options (...) next to the role and then select Test data as role 

 

Important point to remember: If you have configured the workspace so that members have edit permissions, the RLS roles will not be applied to them. Users will be able to see all of the data regardless of your RLS settings. So doubl-check that configuration if your RLS is not working as expected.

 

The above is a general answer. To enable a more focused answer please provide more detail (your DAX filter, your security table, etc.)

 

Cheers,

Vera

View solution in original post

2 REPLIES 2
Vera_Carey
Frequent Visitor

RLS utilizes filters to restrict data access (usually based on roles). If your filter result returns no rows, as would be when an employee is labeled under a region that is not in your data, that employee will see exactly that - nothing.

 

Here is a quick theoretical example. Let’s say your filter DAX look like this:

     [SalesRegion]=”Value”

If your employee in question is assigned to “Europe” the RLS filter will return the following result:

     SalesRegion=”Europe”

…and if “Europe” is not in your underlaying data, then that filter will return no rows (and that is exactly what this employee will see (no rows/nothing).

 

Quick note - You can check if your role/RLS is acting as expected in Power BI Service. To do that, in Power BI Service, select More options (...) next to the role and then select Test data as role 

 

Important point to remember: If you have configured the workspace so that members have edit permissions, the RLS roles will not be applied to them. Users will be able to see all of the data regardless of your RLS settings. So doubl-check that configuration if your RLS is not working as expected.

 

The above is a general answer. To enable a more focused answer please provide more detail (your DAX filter, your security table, etc.)

 

Cheers,

Vera

GilbertQ
Super User
Super User

Hi @JRA21_13_19_25 

 

If the user is not in the RLS table, they will not be able to view any data because there is no row which will allow them to see anything.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

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.

Top Solution Authors
Top Kudoed Authors