topic RLS & Insight (Row level security) in DAX Commands and Tips

RLS & Insight (Row level security)

Aravind_Kumar — Mon, 08 Aug 2022 13:18:12 GMT

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.

Re: RLS & Insight (Row level security)

amitchandak — Mon, 08 Aug 2022 15:53:29 GMT

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

Re: RLS & Insight (Row level security)

Aravind_Kumar — Mon, 08 Aug 2022 17:25:57 GMT

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 : abc@email.com

Role 2 : xyz@email.com, & 1234@email.com

Let me know if I am missing a step ?

Aravind