power-bi-security

# Power BI Security Skill Manage row-level security (RLS) and perspectives for Power BI models. ## Prerequisites ```bash pipx install pbi-cli-tool pbi-cli skills install pbi connect ``` ## Security Roles (RLS) ```bash # List all security roles pbi security-role list # Get role details pbi security-role get "Regional Manager" # Create a new role pbi security-role create "Regional Manager" \ --description "Restricts data to user's region" # Delete a role pbi security-role delete "Regional Manager" ``` ## Perspectives Perspectives control which tables and columns are visible to users: ```bash # List all perspectives pbi perspective list # Create a perspective pbi perspective create "Sales View" # Delete a perspective pbi perspective delete "Sales View" ``` ## Workflow: Set Up RLS ```bash # 1. Create roles pbi security-role create "Sales Team" --description "Sales data only" pbi security-role create "Finance Team" --description "Finance data only" # 2. Verify roles were created pbi --json security-role list # 3. Export full model for version control (includes roles) pbi database export-tmdl ./model-backup/ ``` ## Workflow: Create User-Focused Perspectives ```bash # 1. Create perspectives for different audiences pbi perspective create "Executive Dashboard" pbi perspective create "Sales Detail" pbi perspective create "Finance Overview" # 2. Verify pbi --json perspective list ``` ## Common RLS Patterns ### Region-Based Security Create a role that filters by ...