Solved: Configure RLS

akash0800 · ‎03-09-2023

Hi,

I have a scenario. Currently we have a dataset and few reports built on it. Also RLS is configured so that the users with appropriate credentials can access the report and data (view only and limited flexibility to edit their iwn report).

Now the business is seeing that a group of people should see this new report and all its content. And the old RLS should be applied to all other content of the dataset.

Can anyone help me on how this can be achieved.

I am thinking that there should be a new report level security added to the new report so that the old RLS will still work under this.

Thanks,

Akash

rachelgomez1234 · ‎03-10-2023

Go to the Modeling tab and then select Manage Roles Function.
Create a new role, select the table which you want to get filtered based on the role, and then create a Dax statement to filter this table.
Once the filters are specified click save.
Now the role is created.

Regards,

Rachel Gomez

View solution in original post

rachelgomez1234 · ‎03-10-2023

Go to the Modeling tab and then select Manage Roles Function.
Create a new role, select the table which you want to get filtered based on the role, and then create a Dax statement to filter this table.
Once the filters are specified click save.
Now the role is created.

Regards,

Rachel Gomez