Forum Discussion
RLS & Insight (Row level security)
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.
2 Replies
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
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
