powerbi-modeling
๐ฏSkillfrom github/awesome-copilot
|Guides Power BI users in creating optimized semantic models by providing expert advice on DAX, relationships, star schemas, and model best practices.
Overview
A Power BI semantic modeling assistant skill for GitHub Copilot that guides users in building optimized, well-documented data models following Microsoft best practices. It integrates with the Power BI Modeling MCP Server to connect to active models and provides hands-on guidance for star schema design, DAX measures, relationship configuration, row-level security, and performance optimization.
Key Features
- Live model connection and analysis: Connects to active Power BI models (Desktop or Fabric) via MCP tools, enabling real-time inspection of tables, relationships, measures, and model statistics before providing guidance.
- Star schema and relationship design: Guides proper classification of dimension and fact tables, configures one-to-many relationships with appropriate cardinality and cross-filter direction, and manages dedicated date tables.
- DAX measures and naming conventions: Creates measures with proper formatting, descriptions, and human-readable naming (
Customer NamenotCUST_NM), including support for calculation groups and field parameters. - Row-level security implementation: Helps design and configure RLS policies with proper security role operations, effective permission checks, and testing workflows.
- Model quality assessment: Evaluates models against a comprehensive checklist covering table classification, documentation completeness, hidden technical fields, measure explicitness, and relationship correctness.
Who is this for?
This skill is designed for Power BI developers and data analysts who build semantic models and want Copilot to enforce best practices automatically. It is particularly valuable for teams managing complex enterprise data models, analysts writing DAX calculations, and anyone responsible for model performance tuning, documentation, or security configuration in Power BI.
Same repository
github/awesome-copilot(315 items)
Installation
npx vibeindex add github/awesome-copilot --skill powerbi-modelingnpx skills add github/awesome-copilot --skill powerbi-modeling~/.claude/skills/powerbi-modeling/SKILL.mdSKILL.md
More from this repository10
A community-curated collection of custom agents, prompts, instructions, and skills to enhance GitHub Copilot across different domains, languages, and use cases.
A community-curated collection of custom agents, prompts, instructions, and skills to enhance GitHub Copilot across different domains, languages, and use cases.
Generates comprehensive Product Requirements Documents (PRDs) by systematically analyzing requirements and crafting detailed technical specifications
Expert technical writer guided by the Diataxis framework, creating tutorials, how-to guides, reference docs, and explanation pages for software documentation.
Generates Excalidraw diagrams from natural language descriptions, creating visual representations of processes, systems, relationships, and ideas.
A community-curated collection of custom agents, prompts, instructions, and skills to enhance GitHub Copilot across different domains, languages, and use cases.
Provides Spring Boot best practices covering project setup, dependency injection, REST API design, data access with JPA, security configuration, and testing strategies.
Creates optimized multi-stage Dockerfiles for any language or framework, separating builder and runtime stages to produce smaller, more secure container images.
Creates README.md files for projects.
Merges mature lessons from domain memory files into instruction files, consolidating knowledge with minimal redundancy across global, user, and workspace scopes.