Row Level Security Setup Guide: Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
Power BI Row Level Security (RLS) Documentation | '''Power BI Row Level Security (RLS) Documentation''' | ||
Sample Report: Global HAE Booking Summary Dashboard | Sample Report: Global HAE Booking Summary Dashboard | ||
| Line 9: | Line 9: | ||
Purpose: Control user access to report data based on database permissions. | Purpose: Control user access to report data based on database permissions. | ||
'''1. Purpose of This Document''' | |||
This document outlines the '''Row Level Security (RLS) configuration and management process''' implemented in the Power BI Global HAE Booking Report. | This document outlines the '''Row Level Security (RLS) configuration and management process''' implemented in the Power BI Global HAE Booking Report. | ||
| Line 22: | Line 23: | ||
· Access is controlled securely and consistently across the company. | · Access is controlled securely and consistently across the company. | ||
2. Overview of the RLS Design | '''2. Overview of the RLS Design''' | ||
The RLS model uses the user email identification to determine which data a user is allowed to see. | The RLS model uses the user email identification to determine which data a user is allowed to see. | ||
| Line 35: | Line 37: | ||
The system then applies DAX logic to determine the data that the user can view. | The system then applies DAX logic to determine the data that the user can view. | ||
3. Access Categories | '''3. Access Categories''' | ||
Users are divided into two access levels | Users are divided into two access levels | ||
Restricted Access Users | |||
Unrestricted Access Users | Unrestricted Access Users | ||
Revision as of 16:14, 7 April 2026
Power BI Row Level Security (RLS) Documentation
Sample Report: Global HAE Booking Summary Dashboard
Dataset: Email Reporting Dataset
Prepared by: PBI Team
Purpose: Control user access to report data based on database permissions.
1. Purpose of This Document
This document outlines the Row Level Security (RLS) configuration and management process implemented in the Power BI Global HAE Booking Report.
The goal of RLS is to ensure that:
· Users only see data relevant to their authorized databases.
· Certain administrators have unrestricted access to all data.
· Access is controlled securely and consistently across the company.
2. Overview of the RLS Design
The RLS model uses the user email identification to determine which data a user is allowed to see.
PowerBI identifies the logged in user using:
USERNAME()
The function returns the email address of the user who is currently accessing the report.
The system then applies DAX logic to determine the data that the user can view.
3. Access Categories
Users are divided into two access levels
Restricted Access Users
Unrestricted Access Users