powerbi-modeling

Builds and optimizes Power BI semantic models using MCP tools for DAX measures, relationships, and RLS.

Updated Mar 25, 2026
One-click install
npx skills add https://github.com/lettucebo/Skills --skill powerbi-modeling-lettucebo
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: powerbi-modeling
Source: https://github.com/lettucebo/Skills/tree/main/skills/power-platform/powerbi-modeling
Command: npx skills add https://github.com/lettucebo/Skills --skill powerbi-modeling-lettucebo

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Designing Power BI semantic models that follow Microsoft best practices is difficult: star schema design, relationship cardinality, DAX measure patterns, and row-level security all have subtle pitfalls that hurt performance and correctness. This Skill connects to your live model, audits it against best practices, and applies fixes directly. ## Core Features & Use Cases - Model Analysis & Health Checks: Connects via the Power BI Modeling MCP server to list tables, relationships, and measures, then evaluates star schema design, naming conventions, and documentation coverage. - Measure & Relationship Management: Creates and updates DAX measures with descriptions, format strings, and display folders; configures relationship cardinality and cross-filter direction. - Security & Performance Guidance: Implements row-level security roles (static and dynamic with USERPRINCIPALNAME) and applies optimization techniques like data type reduction and variable-based DAX. - Use Case: Ask the assistant to review your Sales model; it connects, finds bidirectional relationships and undocumented measures, then creates properly formatted measures and fixes cross-filtering. ## Quick Start Connect to my open Power BI model and audit it for star schema, naming, and relationship best practices, then create a Total Sales measure with a description.

Frequently Asked Questions about powerbi-modeling

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create a DAX measure in Power BI programmatically?▼

Use the measure_operations Create operation with the measure name, table, DAX expression, format string, and description. This Skill generates properly formatted measures following naming conventions and adds documentation automatically.

How do I set up row-level security in Power BI?▼

Apply RLS filters on dimension tables rather than fact tables so filters propagate through relationships. Use dynamic RLS with USERPRINCIPALNAME() and a security mapping table so rules scale without creating a role per user group.

What is the best relationship configuration for Power BI models?▼

Prefer one-to-many relationships from dimension to fact tables with single-direction cross-filtering. Avoid bidirectional filters and many-to-many relationships unless required, since they increase query complexity and can create ambiguous paths.

Does this Skill require the Power BI Modeling MCP server?▼

Yes, the Power BI Modeling MCP server is required to connect to and modify semantic models. It provides connection, table, measure, relationship, and security role operations; without it the Skill can only give general guidance.

Why is my Power BI model slow and how can I fix it?▼

Common causes include high-cardinality columns, unnecessary columns, bidirectional relationships, and DAX that filters entire tables. Fixes include removing unused columns, optimizing data types, using variables in DAX, and replacing FILTER on tables with column predicates.