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.
This is my measure for row level security. I look up the username and match the manager should be able to see the employee IDs corresponding to the manager ID.
1 = var stock = LOOKUPVALUE(user_security_dynamic[employee_id]; user_security_dynamic[username]; USERNAME()) RETURN IF(
stock = table1[Manager ID]; 1; 0); but i get this error that a single value for column Manager ID cannot be determined. How can I change this? Thanks
Solved! Go to Solution.
Hi @niveekiwi ,
You may refer to Row-level security (RLS) with Power BI.
According to your sample data. I create a role in the Manage roles as follows.
[Username] = username()
The test is this.
You can check more details from here.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @niveekiwi ,
You may refer to Row-level security (RLS) with Power BI.
According to your sample data. I create a role in the Manage roles as follows.
[Username] = username()
The test is this.
You can check more details from here.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@niveekiwi , how is your data structured? Can you share sample data
In between see if these two can help
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
Hi thanks for the link; I did try to impelemnt the links you sent; but those are not for my case.
My user security dynamic looks like this. An employee ID can have multiple usernames.
Username | employee_id |
Domain\A | 1017 |
Domainb\A | 1017 |
Domain\B | 1019 |
Domain\C | 2020 |
The rows Im trying to filter looks like this. If employee ID from above table matches with Manager_ID; then those rows should be seen.
Employee | manager_id |
X | 1017 |
X | 1017 |
Y | 1017 |
Z | 1019 |
E | 2020 |
@niveekiwi That error regarding multiple values generally means you need to wrap a column reference in an aggregation function like MAX or MIN. This may help: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Hierarchical-Row-Level-Security/m-p/...
Create a calulated column with name "Flag"
FLAG=1
Now write the RLS code on Flag
Flag=IF(table1[employee_id] IN SELECTCOLUMNS(Filter('user_security_dynamic','user_security_dynamic'[UserName]=UserName()),"Id",[Emplyee_id]),1,0)
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |