帮助用户创建、编辑、部署并优化 Power BI 语义模型及其数据刷新与权限配置。
复制安装指令,让 AI 自动完成配置 · 推荐新手
请帮我安装 askskill 上的 "semantic-model-authoring" 技能: 1. 下载 https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/plugins/powerbi-authoring/skills/semantic-model-authoring/SKILL.md 2. 保存为 ~/.claude/skills/semantic-model-authoring/SKILL.md 3. 装好后重载技能,告诉我可以用了
请为销售数据设计一个 Power BI 语义模型,使用 Import 模式,包含事实表 Sales 和维度表 Date、Product、Customer,并给出建议的关系、关键列和基础度量值。
输出语义模型设计方案,包括表结构、关系设计、关键字段和常用 DAX 度量值建议。
请为现有 Power BI 语义模型添加“同比销售额增长率”和“滚动12个月销售额”两个 DAX 度量,并检查是否有性能优化建议。
输出可用的 DAX 度量公式,并附上性能优化建议与建模注意事项。
请说明如何将 PBIP 项目中的语义模型部署到 Fabric 工作区,配置数据源凭据,设置刷新计划,并给出需要检查的权限项清单。
输出部署步骤、刷新与凭据配置流程,以及权限检查清单。
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 |
|---|
…