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

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. 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
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.

Top Solution Authors