Securing Your Power BI Data with Row-Level Security: A Step-by-Step Guide

Introduction:

Power BI is one of the most popular Business Intelligence tools. It is mostly recognized for its built-in eye-candy visuals, Insights, DAX, and amazing dashboarding features. But what about data security in Power BI?

Is there a way to secure your data on Power BI dashboards?
Yes, we can use Row Level Security i.e., RLS on the visuals.

Row-level security
Power BI provides a security feature known as Row-level security (RLS). Row-level security is used to manage data access for an individual. In row level security we can set filters to restrict or allow data to designated users. These filters and accesses are managed by the Power BI service admin. The admin can provide, remove, and edit the access to other employees within an organization. RLS needs to be set up on the Power BI desktop while creating the report, and the security is managed and maintained on the server.

Create Row level security:
The steps required for creating RLS on the dashboard are as follows:

1. Go to modeling
2. Go to manage role
3. Click on Create
4. Rename to avoid ambiguity
5. Go to the table, click on the 3 dots, and then click on Add a filter
6. Now select the column you want to create your filter