Dynamic RLS

[PBIraja]

Hi all

I need help

Power bi row level security dynamic:

User want to see his total region data his total branch data how can we implement RLS in this  case.

Thanks,

Raja

[amitchandak · Accepted solution]

@PBIraja , One of the ways to create a table region-wise that does not have RLS

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous · Accepted solution]

Hi @PBIraja ,

Could you tell me if you want all users to see the total data, or can some users see?

If you certain users to see all. Please have a try.

• Create two roles.

This option works if you already have a security group that contains all the users to see all and can add that in PowerBI.com.

Users to see all

Create a second role that has no filters. Add the users to see all to this role in PowerBI.com

Basic User Role

This is what you already have - filters the data based on something.

I have also found a similar post, please refer to it so see if it helps you.

How do I setup RLS for users to see all data? 

• create a new role without any filter in it , then add user in that role.
• Details:  Row-level security (RLS) with Power BI 
•           this post 

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@PBIraja , One of the ways to create a table region-wise that does not have RLS

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.