powerbi-modeling

Builds and optimizes Power BI semantic models with DAX measures, relationships, and RLS.

2|Updated Jan 26, 2026
One-click install
npx skills add https://github.com/Nzettodess/Awesome-Agent-Skills --skill powerbi-modeling-nzettodess
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: powerbi-modeling
Source: https://github.com/Nzettodess/Awesome-Agent-Skills/tree/main/Skills/Data%20Analytic/Data%20Modeling/powerbi-modeling/powerbi-modeling
Command: npx skills add https://github.com/Nzettodess/Awesome-Agent-Skills --skill powerbi-modeling-nzettodess

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 authoring, naming conventions, and row-level security all require specialized knowledge, and mistakes lead to slow, ambiguous, or insecure models. ## Core Features & Use Cases - Model Analysis and Health Checks: Connects to the active Power BI model via the Power BI Modeling MCP server to inspect tables, relationships, and measures before recommending improvements. - Guided Modeling Tasks: Creates and updates DAX measures, configures relationship cardinality and cross-filter direction, implements row-level security roles, and applies naming and documentation conventions. - Performance Optimization: Reduces model size and query time through data type optimization, cardinality reduction, variable-based DAX patterns, and aggregation strategies. - Use Case: A data analyst asks to add a "Total Sales" measure with proper formatting and description, fix a bidirectional relationship causing ambiguous paths, and document all dimension columns — the skill inspects the live model and applies each change through MCP operations. ## Quick Start Connect to my open Power BI model, review its tables and relationships against star schema best practices, and create a formatted 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, home table, DAX expression, format string, and description. The skill connects to the active model first, then creates explicit measures like Total Sales following naming and documentation best practices.

How do I design a star schema for Power BI?▼

Separate descriptive attributes into dimension tables (Customer, Product, Date) and measurable events into fact tables (Sales, Orders), linking them with one-to-many relationships. Keep a consistent grain per fact table and always include a marked date table.

Should I use bidirectional relationships in Power BI?▼

Bidirectional cross-filtering should be avoided by default because it hurts performance and can create ambiguous filter paths. Prefer single-direction filters and use the CROSSFILTER function inside specific DAX measures when bidirectional behavior is genuinely needed.

How do I implement dynamic row-level security in Power BI?▼

Apply RLS filters on dimension tables using USERPRINCIPALNAME() matched against a security mapping table that links user emails to regions or entities. Dynamic RLS scales better than static per-region roles because no role changes are needed when users change.

Why is my Power BI model slow and how do I optimize it?▼

Slow models usually have unnecessary columns, high-cardinality fields, wrong data types, or DAX that filters entire tables. Remove unused columns, prefer integer keys, use variables to avoid recalculation, replace division operators with DIVIDE, and test with Performance Analyzer or DAX Studio.

What tools are required to use Power BI model automation?▼

The Power BI Modeling MCP server is required to connect to and modify semantic models, providing connection, table, column, measure, relationship, and security role operations. The Microsoft Learn MCP server is optional for researching current documentation and best practices.