用于执行 DAX 查询并检查 Fabric Power BI 语义模型元数据。
复制安装指令,让 AI 自动完成配置 · 推荐新手
请帮我安装 askskill 上的 "semantic-model-consumption" 技能: 1. 下载 https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/skills/semantic-model-consumption/SKILL.md 2. 保存为 ~/.claude/skills/semantic-model-consumption/SKILL.md 3. 装好后重载技能,告诉我可以用了
在指定的 Microsoft Fabric Power BI 语义模型上执行以下 DAX 查询: EVALUATE TOPN(10, 'Sales') 请返回查询结果表。
返回该 DAX 查询的结果表,显示前 10 行 Sales 数据。
请使用 INFO 函数查询这个语义模型的元数据,列出所有表名;如果可行,请执行类似 INFO.VIEW.TABLES 的查询并返回结果。
返回模型中的表清单及相关元数据字段。
帮我检查这个语义模型中的度量值元数据,列出所有 measures,并返回指定 measure 的表达式定义与所属表。
返回度量值列表,以及目标度量值的 DAX 表达式和所属表信息。
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
| Task | Reference | Notes |
|---|---|---|
| Finding Workspaces and Items in Fabric | COMMON-CLI.md § Finding Workspaces and Items in Fabric | Mandatory — READ link first [needed for finding workspace id by its name or item id by its name, item type, and workspace id] |
| Fabric Topology & Key Concepts | COMMON-CORE.md § Fabric Topology & Key Concepts | Hierarchy; Finding Things in Fabric |
| Environment URLs | COMMON-CORE.md § Environment URLs | Production (Public Cloud) |
| Authentication & Token Acquisition | COMMON-CORE.md § Authentication & Token Acquisition | Wrong audience = 401; covers token audiences, delegated vs app permissions, OAuth flows, identity types, and Entra app registration |
| Core Control-Plane REST APIs | COMMON-CORE.md § Core Control-Plane REST APIs | Includes workspace/item CRUD, resolve-by-name, pagination, LRO polling, and rate-limiting patterns |
| OneLake Data Access | COMMON-CORE.md § OneLake Data Access | Requires storage.azure.com token, not Fabric token; covers URL structure, ADLS Gen2 parity, and shortcuts |
| Job Execution | COMMON-CORE.md § Job Execution | Run On-Demand Job; Get / Cancel Job |
| Capacity Management | COMMON-CORE.md § Capacity Management | List Capacities; Assign Workspace to Capacity |
| Gotchas, Best Practices & Troubleshooting | COMMON-CORE.md § Gotchas, Best Practices & Troubleshooting | Common Errors; Best Practices |
| Tool Selection Rationale | COMMON-CLI.md § Tool Selection Rationale | |
| Authentication Recipes | COMMON-CLI.md § Authentication Recipes | az login flows, environment detection, token acquisition, and debugging |
Fabric Control-Plane API via az rest | COMMON-CLI.md § Fabric Control-Plane API via az rest | Always pass --resource; includes workspace/item operations, pagination, and LRO patterns |
OneLake Data Access via curl | COMMON-CLI.md § OneLake Data Access via curl | Use curl not az rest (different token audience); file list/read/upload/delete and directory creation |
| SQL / TDS Data-Plane Access | COMMON-CLI.md § SQL / TDS Data-Plane Access | sqlcmd (Go) connect, query, CSV export, service principal auth, and connection parameter discovery |
| Job Execution (CLI) | COMMON-CLI.md § Job Execution | Run notebooks/pipelines, refresh semantic models, check/cancel jobs |
…
帮助你在 Microsoft Fabric 中搭建端到端青铜白银黄金湖仓分层与数据管道。
帮助将 Azure HDInsight 的 Spark、Hive 与 Oozie 工作负载迁移到 Microsoft Fabric。
跨工作区查找 Microsoft Fabric 项目并返回所属工作区与相关 ID。
帮助你创建、编辑、部署并优化 Power BI 语义模型与 DAX 性能。
帮助你开发 Microsoft Fabric Spark 工作流、编写调试 Notebook 代码并管理湖仓与资源。
扫描并评估 Power BI Gen1 数据流,生成迁移快照并执行升级为 Gen2.1 副本。
用自然语言查询 Power BI 报表与仪表板,快速获得业务数据答案。
读取并分析 Fabric 语义模型,查询 Power BI 数据集与模型定义。
通过自然语言查询 Microsoft Fabric 工作区、表、作业和依赖关系
通过自然语言操控 Power BI,快速生成度量、解释指标并优化数据模型。
通过命令行对 Fabric 仓库与湖仓数据执行只读 T-SQL 查询、探查与导出。
为 SQL Server 提供语义理解与安全交互能力