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