Limit Report Access by User

Anonymous This is the use case of Row-Level Security. Row-level security (RLS) can be used to restrict data access for given users - https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

Hi Anonymous 

As Anonymous  said , you can apply RLS for reports . RLS is divided into two types: dynamic and static .

If you don't have too many roles to set up, you can use static RLS. Dynamic RLS is a good choice if you have a lot of roles to set up (roles here refer to access rights that can access different data) . Here are some documents about RLS , you can refer to them .

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

How to Implement Row Level Security in Power BI- Static RLS (perficient.com)

Dynamic Row Level Security in Power BI - Acuity Training

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi, this seems like it would work well but I am struggling with the "failed to resolve principal name" when using the dynamic option.

Are there common mistakes that might trip this up?

Yes it is.

Also, could you use another text field like Business Unit to control it by a group of users?

Thanks

Thanks. That works.  Can you set this logic to work on something like a business unit or group?  I need something to contrrol this more by group than an individual. 

Hi,

I am still struggling with how to handle this on the user end.  Should I use a parameter to filter the data for each contract?

If so, how would I let the user adjust this in Power BI service?

Hi,

To make this a bit more complicated, what is the best way to dynamically filter the data.  Basically, in Power BI service, I need the user to be able to select the contract and have the data update accordingly.  Can I use a parameter for that?

Thanks