RLS & Insight (Row level security)

[Aravind_Kumar]

Good Morning : Building a cost center report, i have tested RLS (Row level security) by creating role and assiging it to email id.

My requirement is simple, all the records will have  a cost center in each line item, and i will group the cost centers to create a role and assign it to one or multiple users.

So single dashboard shared by several users based on above criteria.

This is my first RLS set up, so do i need to consider any other factors, because this is a sensitive information shared to Senior leadership team, so I want to make sure i do not miss anything ?

Thank you.

[amitchandak]

@Aravind_Kumar , You need to have a table(Say TS1)  with the cost center and user email. joining back with cost center of you table.

If join is bi-directional , then you check the box for bi directional security

else make it single direction from TS1 to your table

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk

[Aravind_Kumar]

Hello Amit :

In Manage role, we create the role bringing the cost centers and then assign the email id against the role in the Web portal (power bi) is that how its done ? Not sure why we need to create a Table separately ?

Under Manage role

Role 1 : Cost center 1, 2 & 5

Role 2 : Cost center 6, 9, 23

In PowerBI Web page Assingn these role to user id emails:

Role 1 : [email protected]

Role 2 : [email protected], & [email protected]

Let me know if I am missing a step ?

Aravind