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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Post Partisan
Post Partisan

RLS different level



I have a dimension department  table that filter the factstable. One ofthis table is the sales pr employee. How can I create a RLS where the manager of a department can see the sales of ALL department but not sales of the employees of other departments, only his or or possibly some other departments?

So show all sales on the aggregated departmentlevel but RLS only on specific employees.

Super User
Super User

Hi @Coan7 ,


The first thing to make this successful would be that your data actually is separated that way so it is possible.  You have to be able to slice your data in that manner or RLS won't work.


Assuming that your data can be sliced in that manner, you just create roles that have both department and employee filters.  Then, in the Service, you put that manager into the apropriate two roles - the one that can see those department(s) that you want and the employee(s) that you want.

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

Proud to be a Datanaut!
Private message me for consulting or training needs.

I end up in making new calculations based on userprinciplename. Duplicate/seperate data would be to much.

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors