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.
Hi All,
We have dashboards created for different countries. For each country we have User hierarchy. Each Area managers have multiple supervisors and each supervisor manages different Sales Rep.
I want to create a data security for these users based on their designation. Sales Rep should see only that store data where he has conducted the survey. Supervisor should see all those stores that are visited by the sales Reps he is managing and Area manager should see all the stores that his supervisor is managing.
We have huge number of Sales Reps and hence creating roles(RLS) for each Sales Rep is not an option. Is there any other way we can do this?
Thanks in Advance,
Bhavya
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 |
---|---|
14 | |
4 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
9 | |
6 | |
3 | |
3 |