$ loading_
Create, edit, deploy, and optimize Power BI semantic models and DAX.
Copy the install command and let the AI configure it · recommended for beginners
Please install the "semantic-model-authoring" skill from askskill: 1. Download https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/skills/semantic-model-authoring/SKILL.md 2. Save it as ~/.claude/skills/semantic-model-authoring/SKILL.md 3. Reload skills and tell me it's ready
Create a Power BI semantic model for sales data using Import mode. Include a Sales fact table and Date, Product, and Customer dimensions, define proper relationships, and add base measures such as total sales, order count, and average order value.
A well-structured semantic model plan with tables, relationships, key measures, and modeling guidance.
Review the existing Power BI semantic model, add DAX measures for year-over-year sales growth, rolling 12-month sales, and gross margin, then identify performance issues and provide optimized versions.
New DAX measures, explanations of performance issues, and more efficient optimized formulas.
Deploy the semantic model from this PBIP project to a Fabric workspace, verify refresh, data source, and permission settings, and suggest naming, descriptions, and field organization improvements to make it better for AI/Copilot.
A deployment and configuration checklist plus recommendations to improve semantic clarity and AI readiness.
Update Check — ONCE PER SESSION (mandatory) The first time this skill is used in a session, run the check-updates skill before proceeding.
- GitHub Copilot CLI / VS Code: invoke the
check-updatesskill.- Claude Code / Cowork / Cursor / Windsurf / Codex: compare local vs remote package.json version.
- Skip if the check was already performed earlier in this session.
CRITICAL NOTES
- To find the workspace details (including its ID) from workspace name: list all workspaces and, then, use JMESPath filtering
- To find the item details (including its ID) from workspace ID, item type, and item name: list all items of that type in that workspace and, then, use JMESPath filtering
- Always consider the Tool selection priority when choosing which tool to use for each operation. Do not default to TMDL edits or
az restif MCP is available and connected to the target model.
Use this decision tree to route to the correct workflow based on user intent:
| User wants to... | Workflow |
|---|---|
| Create a semantic model from scratch | Create new semantic model |
| Add/edit semantic model objects (e.g. measures, tables, columns, relationships) | Modify an Existing Model |
| Write or refactor DAX code | Modify an Existing Model |
| Improve DAX query or measure performance | Optimize DAX Performance |
| Analyze semantic model against best practices | Analyze Best Practices |
| Prepare a semantic model for AI consumption (Copilot / Data Agents) | Semantic Model AI Readiness |
| Deploy a model to a Fabric workspace | Deploy to Fabric |
| Refresh a semantic model | Refresh Semantic Model |
| Configure data sources, parameters, or permissions | Manage Semantic Model in Fabric |
| Bind a semantic model to a Fabric connection (or unbind) | Bind Semantic Model to a Connection |
| Export / Get semantic model definition as PBIP | Export to PBIP |
Load these references on demand when a workflow step requires them. Do not load all at once.
| Topic | Reference | When to load |
|---|
…
Build end-to-end Bronze, Silver, and Gold lakehouse pipelines in Microsoft Fabric.
Create, update, and publish Microsoft Fabric Eventstream topologies via REST APIs.
Migrate HDInsight Spark, Hive, and Oozie workloads to Microsoft Fabric.
Search Microsoft Fabric items across workspaces and return locations and IDs.
Diagnose Spark failures, session issues, and performance bottlenecks in Microsoft Fabric.
Scan, assess, and upgrade Power BI Gen1 dataflows into Gen2.1 copies.
Run DAX queries and inspect Fabric Power BI semantic model metadata.
Enable AI agents to create and manage Power BI semantic models.
Discover Power BI assets, run DAX, and generate executive HTML reports.
Control Power BI with natural language to build measures and improve models.
Discover and connect Power BI workspaces and semantic models for data access.
Define, validate, and visualize semantic metrics with trust scoring and BI integrations.