Security Level In Power BI

Power BI 

Security Level In Power BI

There are 2 levels of security in Power BI

1. Data level/Row-level security: Data is visible based on their login in a report. As per assigned roles only they view data in the report

2. Access Level: The security is applied at the workplace/App level. It means managing security in the workspace by giving edit, view and browse..etc options for a workspace to members 

  

Row Level Security :

EX : 

→ Consider the situation where you need to restrict the data/row level at a country level. Let's see how to implement row-level security.

→ Creating roles based on the country column 

→ Next, go to the Modeling tab and click on Manage Roles

→ Click on Create a role - "Query1" and Select Place on Add Filter

→  Create a DAX Calculation  [place] = "US"

→  Similarly, create roles for US and INDIA countries.

Now, Click on View as in modeling Tab

See Data filtering based on row-level security :

Assigning members to roles in Power BI Service:

Goto Security in datasets

In Security you can add members to roles and test roles :

Once Add Roles Click On Save

Once they login into their service using their account. They can see only data as per role

Create one of the new workspaces

In order to create a workspace in service, Need pro/ Premium Account

Start by creating the workspace. Select Workspaces > Create a workspace.

→ Give the workspace a unique name. If the name isn't available, edit it to come up with a unique name.
The app you create from the workspace will have the same name and icon as the workspace.

→ Here are some optional items you can set for your workspace:

 Upload a Workspace image. Files can be .png or .jpg format. File size has to be less than 45 KB.

Specify a Workspace OneDrive to use a Microsoft 365 group file storage location.

Add a Contact list. By default, the workspace admins are the contacts.

Allow contributors to update the app for the workspace

To assign the workspace to a Dedicated capacity, on the Premium tab select Dedicated capacity.

→ Select Save.
Power BI creates the workspace and opens it. You see it in the list of workspaces you’re a member of.

Give access to your workspace

Anyone who has an admin role in a workspace can give others access to the workspace by adding them to the different roles. Workspace creators are automatically admins. See Roles in the new workspaces for an explanation of the roles.

 Note

To enforce row-level security (RLS) for Power BI Pro users browsing content in a workspace, assign the users the Viewer Role. See Roles in the new workspaces for an explanation of the different roles.