执行 DAX 查询并检查 Power BI 语义模型元数据,快速获取表、列、度量与关系信息。
复制安装指令,让 AI 自动完成配置 · 推荐新手
请帮我安装 askskill 上的 "semantic-model-consumption" 技能: 1. 下载 https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/plugins/fabric-consumption/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 行数据。
请使用 INFO 函数查询该语义模型的元数据,列出所有表名及其基本属性。
返回模型中的表列表,以及每个表的关键元数据信息。
请检查该 Power BI 语义模型中的所有度量,并返回每个度量的名称与 DAX 表达式。
返回度量名称及对应的 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 Spark 与数据工程流程,编写调试 Notebook 代码并管理湖仓资源。
通过命令行分析 Fabric 数据仓库性能,定位慢查询与资源压力并给出优化建议。
通过只读 API 检查 Fabric 中现有告警、通知与自动化动作配置
检查 skills-for-fabric 技能集是否有更新,并展示版本差异与更新日志。
帮助你查询 Fabric Eventhouse 数据、分析时序趋势并监控摄取状态。
用自然语言查询 Power BI 报表与仪表板,快速获得业务数据答案。
执行 Power BI 语义模型的原始 DAX 查询并检查模型元数据。
用于执行 DAX 查询并检查 Fabric Power BI 语义模型元数据。
用于创建、编辑、部署并优化 Power BI 语义模型及其刷新与权限配置。
帮助用户创建、编辑、部署并优化 Power BI 语义模型及其数据刷新与权限配置。
帮助你创建、编辑、部署并优化 Power BI 语义模型与 DAX 性能。
创建、编辑并部署 Power BI 语义模型,优化 DAX 性能与刷新配置。