powerbi-modeling
Power BI semantic modeling assistant for building optimized data models. Use when working with Power BI semantic models, creating measures, designing star schemas, configuring relationships, implementing RLS, or optimizing model performance. Triggers on queries about DAX calculations, table relationships, dimension/fact table design, naming conventions, model documentation, cardinality, cross-filter direction, calculation groups, and data model best practices. Always connects to the active model
Security Assessment
About powerbi-modeling
The 'powerbi-modeling' skill is designed to assist users in creating and optimizing Power BI semantic models, ensuring that these models are built following industry best practices. This skill primarily addresses the need for efficient data modeling within Power BI, with a focus on ensuring models are structured for performance, scalability, and usability. It helps users design star schemas, define measures and relationships, implement row-level security (RLS), and optimize overall model performance. By automatically connecting to the active Power BI model, the skill ensures guidance is contextually relevant and tailored to the specific model the user is working with.
FAQ
How does the powerbi-modeling skill connect to my Power BI model?
The skill automatically connects to the active model first using the Power BI Modeling MCP tools to analyze the model structure before offering guidance.
What prerequisites are required to use this skill?
The skill requires the Power BI Modeling MCP Server to be configured and running. Optionally, the Microsoft Learn MCP Server can be used for additional research on best practices.
What specific areas does the skill help improve in Power BI models?
The skill helps optimize star schema design, table relationships, DAX measures, model documentation, naming conventions, row-level security (RLS), and performance tuning.
Are there any limitations when using this skill?
The skill requires a connection to an active Power BI model, either through Desktop or Fabric. It also relies on the Power BI Modeling MCP Server to interact with the models.
Install powerbi-modeling
Quick Setup:
- Copy the skill folder to
.claude/skills/ - Claude will automatically detect and use the skill
Repository
github/awesome-copilot