Role Level Security - can I only add some people?

[AliceW]

Hello everyone,

I could really use your help. I have around 100 people in a workspace, and I want to restrict stuff for only about 10 of them.

What I have as tables:

Table: Company Tree

Table: Company with Roles (a duplicate of the above)

Table: Opportunities

Existing Connections:

- Company Tree to Opportunities (1 to many);

- Company with Roles to Opportunities (1 to many);

What I need for Company with Roles:

- One role for the 10 people I need to only see their region and;

- The others to see everything without having to add all their names to a role without restrictions.

What I need for Company Tree:

- That the row-level security in Company with Roles don't impact the reports which don't use this table.

What I did and got:

- I created a role ('Limited') in Company with Roles and published the dataset;

- It blocked access to every report which didn't even use this table for all users not added in that 'Limited' role.

Please please tell me I don't need to add 90 people in a role just for them to see no restrictions...

Thanks,

Alice

[amitchandak · Accepted solution]

@AliceW , refer if groups can help

https://www.youtube.com/watch?v=oxYQ2GGefrs

[amitchandak · Accepted solution]

@AliceW , refer if groups can help

https://www.youtube.com/watch?v=oxYQ2GGefrs

[AliceW · Accepted solution]

Hi Amit,

I ended up figuring it out by myself: if I duplicate the Tree table in Power Query ('duplicate query'), it will also duplicate the roles.

However, if I copy the table directly in the dataset (Tree with Roles = Tree), the roles will keep separate.

Sweet victory!

Thank you!

Alice