用于创建、编辑、部署并优化 Power BI 语义模型及其刷新与权限配置。
复制安装指令,让 AI 自动完成配置 · 推荐新手
请帮我安装 askskill 上的 "semantic-model-authoring" 技能: 1. 下载 https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/plugins/fabric-skills/skills/semantic-model-authoring/SKILL.md 2. 保存为 ~/.claude/skills/semantic-model-authoring/SKILL.md 3. 装好后重载技能,告诉我可以用了
请为销售分析场景设计一个 Power BI 语义模型,使用 Direct Lake 模式,包含事实表、日期维度、客户维度和产品维度,并列出建议的度量值、关系和命名规范。
一份语义模型设计方案,包含表结构、关系、关键 DAX 度量值和建模建议。
请为现有 Power BI 语义模型新增“同比增长率”“滚动12个月销售额”和“毛利率”度量,并检查是否有可优化的 DAX 写法,给出修改建议与原因。
新增度量的 DAX 公式,以及性能与可维护性优化建议说明。
请说明如何将 PBIP 项目中的语义模型部署到 Fabric 工作区,配置数据源凭据与刷新计划,并为分析团队设置合适的访问权限,避免包含报表设计内容。
一套部署、刷新配置和权限设置步骤,适用于 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 |
|---|
…