# Powerbi Rls Ols Pattern Library

> Use when Power BI solutions need RLS or OLS patterns for company, region, plant, warehouse, profit center, cost center, sales org, supplier, customer, HR, or executive access.

- Skill: `rweisssieker-xp/powerbi-rls-ols-pattern-library` (Agent Skill)
- Install (CLI): `npx skillmds@latest add rweisssieker-xp/powerbi-rls-ols-pattern-library`
- Raw SKILL.md: https://api.skillmd.com/api/skills/rweisssieker-xp/powerbi-rls-ols-pattern-library/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: rweisssieker-xp (https://skillmd.com/u/rweisssieker-xp)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/rweisssieker-xp/powerbi-rls-ols-pattern-library

---


# Power BI RLS OLS Pattern Library

Design secure role patterns for enterprise semantic models.

## Pattern Families

- Organization hierarchy: company, region, country, business unit.
- Operations: plant, warehouse, production line, maintenance area.
- Finance: controlling area, profit center, cost center, legal entity.
- Sales/service: sales org, territory, account owner, customer.
- Procurement: supplier, category, buyer group.
- HR and sensitive data: manager hierarchy and OLS-protected fields.

## Output Contract

- Role matrix, user/group source, bridge tables, DAX filter pattern, OLS fields, test users, and validation plan.

## Checks

- Test totals under RLS.
- Avoid security through visuals only.