Forum Discussion
RSL implementation..
Hi,
I set up RSL using intermediate table and relationship. Intermediate table has employee name,Location and region. Below is the structure of intermediate table.
RSL working at employee level.
And i need help in set up to access to Manager and Regional managers. Manager and RM were not part of intermediate table.
Managers:
Bob - SW, Sue - SE ,Mike - SW
RM:
Jeff - E, Ross - W
Any idea how this can be done.
Intermediate table.
| Employee | location | Region |
| a | NE | E |
| b | NE | E |
| c | SE | E |
| d | SE | E |
| e | SW | W |
| f | SW | W |
Thanks in advance..
One approach is to add the regional managers to the intermediate table multiple times, for each of the locations in that region.
3 Replies
One approach is to add the regional managers to the intermediate table multiple times, for each of the locations in that region.
we are using that approach with thousands of users, and we do not see performance issues. We do have an external database (external to Power BI) that does the mapping for us.
