Row Level Security for bulk users

[praveenpearl]

Hi Guys,

Please help me with the below question.

I have Organisational data with the hierarchy from Director to Employee. I have created some dashboards and published them with the RLS for different roles like Director, Manager, Team lead and Employee. I have got two doubts.

1. If I have 150 users in this organization who will be accessing my dashboards based on specified roles, is it mandatory that all the users should have Power BI pro accounts? or is there any other alternative for this?

2. After publishing the reports in Power BI service, we need to give dataset access(Dataset>Security>enetering the user's Emai Id)and also sharing the report to the users email at the Power BI service level 

As per my knowledge, I only know this option to give access to the users. But as I said, if I have 150 users then entering 15 emails twice (For sharing and giving dataset access) is a time taking task.

Is there any other option like grouping all the users falling under the corresponding role giving them dataset access at one shot.

Kindly help me with this and sorry if my question was not clear.

Thanks,

Praveen

[v-juanli-msft · Accepted solution]

Hi @praveenpearl

1.

(1) If you need to share reports to users so that they can see reports with RLS.

With sharing, whether you share content inside or outside your organization, you need a Power BI Pro license. Your recipients also need Power BI Pro licenses, or the content needs to be in a Premium capacity.

(2) If users need to log in with their account so that they can view the reports with RLS  in the App Workplace.

Each member of an app workspace needs a Power BI Pro license. For app users, there are two options.

• Option 1: All business users need Power BI Pro licenses to view your app.
• Option 2: If your app resides in a Power BI Premium capacity, free users in your organization can view app content. Read What is Power BI Premium? for details.

2.

Here is a workaound you could have a try.

On Power BI Service, you can add security group as member of a role. See: Row-level security (RLS) with Power BI 

In this scenario, you can create security groups on O365 admin center: Create, edit, or delete a security group in the Office 365 admin center. Then add all users into corresponding security group.

Best regards

Maggie