Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table Users:
manager_email | employee_name | Path |
mng3@abc.com | Employee 1 | mng1@abc.com|mng2@abc.com|mng3@abc.com |
mng3@abc.com | Employee 2 | mng1@abc.com|mng2@abc.com|mng3@abc.com |
mng3@abc.com | Employee 3 | mng1@abc.com|mng2@abc.com|mng3@abc.com |
mng3_1@abc.com | Employee 4 | mng1@abc.com|mng2@abc.com|mng3@abc.com|mng3_1@abc.com |
mng3_1@abc.com | Employee 5 | mng1@abc.com|mng2@abc.com|mng3@abc.com|mng3_1@abc.com |
There is RLS on the table Users: CONTAINSSTRING ( [Path], USERPRINCIPALNAME()).
I want to have 2 pages on the report:
1) All employees - this is working fine based on the RLS.
2) Direct employees - I want to apply page filter where USERPRINCIPALNAME() = Users[manager_email]. How I could achive that?
Hi, @martinvarbanov
To create a page filter in Power BI that shows only the direct employees of the current user, you can follow these steps:
This will create a page filter that shows only the direct employees of the current user based on the 'manager_email' column in the 'Users' table and the RLS applied to it.
Note that this assumes that you have already set up the RLS on the 'Users' table using the 'CONTAINSSTRING' function as you mentioned. If you have not done so, you will need to set up the RLS first before the page filter will work correctly.
For reference:
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Solved: Dynamic RLS - Microsoft Power BI Community
Row Level Security with SSAS Tabular Live Connection in Power BI - RADACAD
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
25 | |
23 | |
14 | |
11 |
User | Count |
---|---|
78 | |
63 | |
47 | |
17 | |
12 |