Power BI · Chapter 40
Power BI Service: Row-Level Security (RLS) and Object-Level Security (OLS)
City managers see only their city; finance hides salary columns — dynamic RLS, Service assignment, Test as role, and OLS.
Fictional sample data for learning. Brands belong to their owners. Numbers are made up for class.
In this chapter
- Contrast static vs dynamic RLS (USERPRINCIPALNAME).
- Build a mapping table and roles in Desktop.
- Publish roles and assign users or groups in the Service.
- Use Test as role and explain why Viewer (or App) is required.
- Describe object-level security for tables and columns.
- Avoid the top RLS interview mistakes.