skills.rest
lzc0901
lzc0901COMMUNITY
Explore all skills by this author →
GitHub

powerbi-modeling

Provides Power BI modeling guidance for star schemas, DAX measures, relationships, and RLS.

Updated Aug 23, 2026
Search Tags:#data modeling#modeling#RLS#MCP server#star schema#DAX#Power BI
One-click install
npx skills add https://github.com/lzc0901/vibe_coding_template --skill powerbi-modeling-lzc0901
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: powerbi-modeling
Source: https://github.com/lzc0901/vibe_coding_template/tree/main/skills/azure-cloud/powerbi-modeling
Command: npx skills add https://github.com/lzc0901/vibe_coding_template --skill powerbi-modeling-lzc0901

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Power BI modelers face challenges in designing scalable, well-documented semantic models. This Skill provides structured guidance for star schemas, relationships, DAX patterns, RLS, and performance optimization, reducing time spent on model design and validation.

Core Features & Use Cases

  • Guided modeling recommendations for star schema design, naming conventions, and documentation.
  • DAX best practices and pattern guidance for measures and calculated columns.
  • Relationship and cardinality guidance including cross-filter direction and active relationships.
  • RLS design and implementation patterns with security mappings and testing.
  • Model validation and performance checks with references to Microsoft best practices.
  • Example use case: Build a Sales model with Date, Product, and Customer dimensions and a central Sales fact table.

Quick Start

Connect to an active Power BI model using the MCP tools, ask for modeling guidance (e.g., set up a date table, define relationships, or create a measure), and apply recommended patterns to validate and optimize your model.

Frequently Asked Questions about powerbi-modeling

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

FAQPage Schema
How do I design a star schema for my Power BI semantic model?▼

To design a star schema in Power BI, structure central fact tables linked to surrounding dimension tables like Date, Product, and Customer. This Skill provides structured guidance for configuring relationships, naming conventions, and documentation to ensure your semantic model is scalable and optimized.

What is the best way to write DAX measures for Power BI performance optimization?▼

Writing DAX measures for Power BI performance optimization involves applying specific pattern guidance for measures and calculated columns. This Skill provides DAX best practices and model validation checks referencing Microsoft standards to improve your semantic model's performance.

How do I configure row-level security (RLS) in Power BI?▼

Configuring row-level security (RLS) in Power BI requires implementing specific security design patterns and testing mappings. This Skill guides you through RLS design and implementation patterns to enforce data security across your projects effectively.

Do I need a Power BI Modeling MCP Server to use this modeling guidance?▼

Yes, you need an active Power BI Modeling MCP Server and access to model metadata. The Skill connects via MCP tools to analyze your semantic model structure and suggest targeted improvements for relationships, DAX, and RLS.

How do I set up relationships and cardinality in a Power BI data model?▼

Setting up relationships and cardinality in a Power BI data model involves configuring cross-filter direction and active relationship statuses. This Skill provides targeted relationship guidance to validate structure and ensure optimal model design.

Related Skills

Explore More Data & Analytics Skills→
mattmacleod16-svgmattmacleod16-svg
1

powerbi-modeling

Automate Power BI semantic modeling guidance for measures, relationships, and star schemas.

Community
Advanced
githubgithub
37.6k

powerbi-modeling

Guide Power BI semantic model design, DAX measures, and performance optimization.

Official
Advanced
ajilantonyajilantony

powerbi-modeling

Guide Power BI semantic model design, DAX measures, and performance tuning.

Community
Advanced
dtsongdtsong
1

Schema Evaluation

Design and evaluate warehouse schemas including star, snowflake, Vault, OBT patterns.

Community
Advanced