Manage roles and publish in Power BI premium workspace

[Anonymous]

Hi there,

I am new to Power BI and hope to get some advice on how to manage roles and publish reports.

I have created a report which contact financial and payroll data for multiple regions.

I hope to achieve the below:

1. Manager A can only see data re region A (I created a Manager A role by filtering region table to region A)

2. Manager B can only see data re region B (I create a Manager B role by filtering region table to region B)

3. Staff working under manager A can only see data in region A, except for payroll data (I created Staff A role by filtering region table to region A and hiding all fields in payroll table)

4. Staff working under manager B can only see data in region B, except for payroll data (I created Staff B role by filtering region table to region B and hiding all fields in payroll table)

5. staff who is not assigned any of the above roles cannot see anything in the Power BI report, regardless if they are members of the Power BI premium workspace or not e.g. if someone try to share the file, etc, anyone receiving the link cannot see anything unless they are assigned one of the above roles

I tried the above but someone from the same Power BI premium workspace can see my file, even though I have not assigned any role to him.

I am unsure of how to fix this.

Any help / advice is appreciated.

Many thanks.

Kind regards,

Janis

[Anonymous]

Hi @v-angzheng-msft 

Many thanks for your help.  It all makes sense now.  

All the other users are Members in the workspace thus I failed the RLS.  I will look into making user viewers to allow RLS to work.  

Much appreciated for your help.

Kind regards,

Janis

[v-angzheng-msft]

Hi, @Anonymous 

Thanks for your feedback. Could you please mark the post which helps you as Answered since it is working now? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.

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

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

It is important to note that row-level security can only be applied to the viewer role in the workspace. If row-level security does not work for a member of the same workspace who is not assigned a role, perhaps because he is not a viewer in the workspace, change his role to viewer and try again.

For references:

Using RLS with workspaces in Power BI 

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