Forum Discussion

praveenpearl's avatar
praveenpearl
Frequent Visitor
7 years ago
Solved

Row Level Security for bulk users

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 di...
  • v-juanli-msft's avatar
    7 years ago

    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