powerbi-semantic-model
Power BI Semantic Model Skill
This skill provides guidance on how to develop Power BI semantic models.
References
- modeling-guidelines: General best practices for modeling, including star schema design, naming conventions, and DAX measure patterns.
- direct-lake-guidelines: Specific guidelines for working with Direct Lake semantic models, including partition source types and limitations.
- TMDL: Reference for TMDL syntax and properties when working with TMDL code and files.
- pbip.md: Guidelines for working with Power BI Project files (PBIP) that contain semantic models.
- dax-udf-functions-guidelines: Guidelines for creating and using DAX User-Defined Functions (UDFs) to centralize business logic in the model.
- dax-query-guidelines: Guidelines for writing DAX queries against the semantic model for validation and analysis.
- dax-performance-optimization: Guidelines for DAX performance optimization, including storage engine vs. formula engine analysis, anti-pattern detection, and optimization strategies.
IMPORTANT
- Respect the Tool Selection Priority.
- If asked to work with TMDL code or *.tmdl files, load the TMDL reference to understand the syntax and properties of TMDL objects.
- If asked to export or save the semantic model to a PBIP project, make sure you understand the PBIP explained in PBIP reference.
More from ruiromano/powerbi-agentic-plugins
powerbi-report-authoring
Guide to develop Power BI Reports in PBIR format. Use this skill for any development operation against a Power BI Report PBIR file format including (1) Creating new reports on top of semantic models, (2) Editing visuals, pages, and bookmarks, (3) Aligning and laying out visuals, (4) Rebinding reports to different semantic models, (5) Deploying reports to Fabric workspaces, (6) Exporting reports from workspaces. Do NOT use for semantic model development or TMDL (use powerbi-semantic-model), or workspace/pipeline administration (use fabric-cli).
4powerbi-semantic-model-authoring
Develops and manages Power BI Semantic Models. Handles connecting to semantic models for analysis and all development operations including (1) Creating new models, (2) Creating/editing measures using DAX, (3) Creating/editing tables and relationships, (4) Analyzing model best practices, (5) Deploying models to Fabric workspace, (6) Working with PBIP projects containing semantic models, (7) Troubleshooting DAX performance, (8) Refreshing semantic models in Desktop or Fabric service, (9) Creating or editing TMDL code or TMDL files. Does NOT handle report layout/visual authoring, or workspace/pipeline administration (use fabric-cli).
4fabric-cli
Use Microsoft Fabric CLI (fab) to manage workspaces, semantic models, reports, notebooks, lakehouses, and other Fabric resources via file-system metaphor and commands. Use when deploying Fabric items, running jobs, querying data, managing OneLake files, or automating Fabric operations. Invoke this skill automatically whenever a user mentions the Fabric CLI, fab, or Fabric.
3powerbi-pbir
Guide to develop Power BI Reports in PBIR format. Use this skill for any development operation against a Power BI Report PBIR file format including (1) Creating new reports on top of semantic models, (2) Editing visuals, pages, and bookmarks, (3) Aligning and laying out visuals, (4) Rebinding reports to different semantic models, (5) Deploying reports to Fabric workspaces, (6) Exporting reports from workspaces. Do NOT use for semantic model development (use powerbi-semantic-model), TMDL syntax (use powerbi-tmdl), or workspace/pipeline administration (use fabric-cli).
1powerbi-tmdl
Guide to develop against TMDL files or TMDL code. Use this skill when asked to change TMDL code or files (*.tmdl). Includes creating measures with DAX, setting descriptions, working with Power Query M code in partitions, creating RLS roles, and exporting semantic models to TMDL format. Use for any direct manipulation of TMDL syntax or Power BI semantic model definition files.
1