Managing Dataset Permissions in Power BI

Body

This page shows the steps to set the permission for the semantic model (dataset) in Power BI.

Instructions 

Power BI reports are distributed to a broad audience using an app and the consumers do not need a Pro license if the workspace is in a premium capacity.

All app users must have Read or App permission on the underlying semantic model (dataset).  When users are added to App, the dataset permission is automatically added as "App" permission for the all of the dataset in the same workspace. If the dataset is on different workspace, dataset permission needs to be added manually. The steps below show how to set up the permission manually.

 

Steps

  1.  Find the semantic model, click the ellipses next to the model, and choose "Manage Permissions".

    Step1 for manage permission button
     
  2. Check the list of people or group and make sure the user you are trying to add is not on the list. Click "Add user"

    add user screen
     
  3. Uncheck the boxes, enter email addresses, and click "Grant access".

    Grant people access checkboxes
     

    When you share a dataset by managing permissions, by sharing reports, or by publishing an app, you're granting access access to the entire dataset unless row-level security (RLS) limits their access. Report authors may use capabilities that customize user experiences when viewing or interacting with reports, for example hiding columns, limiting the actions on visuals, and others. These customized user experiences do not restrict what data users can access in the dataset. Use row-level security (RLS) in the dataset so that each person's credentials determine which data they can access.

    Please go to Row Level Security in Power BI page for more information.

  4. The access should show as "Read".

    permission status
     
  5. To remove the permission, click the ellipses and change the permission

    remove permission

Additional Source

Environment

  • Power BI

Details

Details

Article ID: 159296
Created
Fri 5/10/24 4:44 AM
Modified
Mon 8/19/24 12:21 PM
Applies To
Faculty
Staff
Community