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.
Is it possible to apply a condition to row level security so if the user pulls in a certain field security is applied? For example, sales managers can see sales for all regions but if they add the customer to the visual then row level security would be applied, and they would only see sales related to their customers. I am using a separate security table with the standard DAX formula to apply row security.
='Customer'[Customer Number]=LOOKUPVALUE('Sales Manager Security'[Customer Number],'Sales Manager Security'[User],USERNAME(),'Sales Manager Security'[Customer Number],'Customer'[Customer Number])
Any assistance is appreciated.
Thanks,
Josh
"if they add the customer to the visual" - how? Via "Personalize Visual" ?
You might be able to use ISFILTERED() but only if they not only add the customer to the visual but it also is somehow restricted.
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 |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |