帮助你创建、编辑、部署并优化 Power BI 语义模型与 DAX 性能。
复制安装指令,让 AI 自动完成配置 · 推荐新手
请帮我安装 askskill 上的 "semantic-model-authoring" 技能: 1. 下载 https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/skills/semantic-model-authoring/SKILL.md 2. 保存为 ~/.claude/skills/semantic-model-authoring/SKILL.md 3. 装好后重载技能,告诉我可以用了
请为销售数据创建一个 Power BI 语义模型,使用 Import 模式,包含事实表 Sales 与维表 Date、Product、Customer,建立合理关系,并给出基础指标如总销售额、订单数、平均客单价。
一个结构清晰的语义模型设计方案,包含表、关系、关键度量值及建模建议。
请检查现有 Power BI 语义模型,新增同比销售增长率、滚动 12 个月销售额和毛利率等 DAX 度量,并指出可能影响性能的写法,给出优化版本。
新增的 DAX 度量、性能问题说明,以及更高效的优化写法建议。
请将这个 PBIP 项目的语义模型部署到 Fabric 工作区,检查刷新、数据源和权限配置,并提出让模型更适合 AI/Copilot 使用的命名、描述和字段整理建议。
部署与配置检查清单,以及提升语义清晰度和 AI 可用性的改进建议。
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 |
|---|
…