创建、编辑并部署 Power BI 语义模型,优化 DAX 性能与刷新配置。
复制安装指令,让 AI 自动完成配置 · 推荐新手
请帮我安装 askskill 上的 "semantic-model-authoring" 技能: 1. 下载 https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/plugins/fabric-authoring/skills/semantic-model-authoring/SKILL.md 2. 保存为 ~/.claude/skills/semantic-model-authoring/SKILL.md 3. 装好后重载技能,告诉我可以用了
请为销售分析场景设计一个 Power BI 语义模型,使用 Direct Lake 模式,包含订单、客户、产品和日期表,建立合理关系,并给出关键度量如销售额、毛利率和同比增长。
一套可实施的语义模型设计方案,包括表结构、关系、存储模式与核心 DAX 度量。
我已有一个 Power BI 语义模型,请新增“近30天活跃客户数”和“复购率”两个度量,并检查现有 DAX 是否存在性能问题,给出优化建议和替代写法。
新增度量定义、性能问题说明,以及更高效的 DAX 改写建议。
请指导我把本地 PBIP 项目的语义模型部署到 Fabric 工作区,配置数据源凭据和刷新计划,并说明需要设置哪些权限才能让分析团队正常使用。
部署步骤、PBIP 处理方式、刷新与数据源配置清单,以及语义模型使用权限建议。
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 |
|---|
…