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
I am implementing RLS in my dashboard where there are two tables, one of managers and other customers.
They do not have a direct relationship/join but there is a relation which is the team they both are on. The managers manage the team and the table contains the column with each users team; m2m relation between team and manager, each manager can have multiple teams and each team can have multiple managers. so I have flattened the data so I have 2 rows for one manager with 2 teams (to make thing easier). The customers also have a team column in their table.
Issues:
1- Managers need to be able to see only customers of their teams
2- Customer team name can have suffix , for example Sales in manager is equivalent in Sales U and Sales GP in customer.
I can't seem to make this work. I tried simple Customer[team] = Manager[team], it didnt work. Neither did using IN and Search functions.
Any help is much appreciated.
Thanks
Hi @Anonymous
Can you create a data sample that represents your scenario?
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 |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |