用自然语言查询 Power BI 报表与仪表板,快速获得业务数据答案。
复制安装指令,让 AI 自动完成配置 · 推荐新手
请帮我安装 askskill 上的 "fabriciq" 技能: 1. 下载 https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/plugins/fabric-skills/skills/fabriciq/SKILL.md 2. 保存为 ~/.claude/skills/fabriciq/SKILL.md 3. 装好后重载技能,告诉我可以用了
请帮我查询这个 Power BI 报表中的销售数据:上个月销量最高的前 10 个产品是什么?按销量从高到低列出,并附上各自销售额。
返回前 10 个产品的自然语言结论,并附带销量与销售额排序结果。
查看当前 Power BI 仪表板,比较华东区和华南区本季度销售额、毛利率与同比变化,总结哪个区域表现更好。
输出两大区域的关键指标对比,并给出简明业务判断。
帮我发现这个工作区里可用的 Power BI 报表和仪表板,并说明每个报表大致包含哪些业务主题,方便我继续提问。
列出可用报表与仪表板清单,并概述各自的数据主题与用途。
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 artifact details (including artifact ID) from a search query: use
DiscoverArtifactswith the search term — do not call workspace/item list APIs- To find the semantic model behind a report: call
GetReportMetadataand extract the model GUID from the response- When the user provides a Power BI URL: call
ResolveReportIdFromUrlto get the correct report GUID before proceeding
⚠️ STOP — Read this entire skill document in full before taking any action. Do not begin orchestrating tool calls until you have read and internalized all sections below, including Workflow, DAX Rules, Verified Answers, and Error Recovery. Skipping ahead leads to incorrect queries and missed instructions.
You help users analyze Power BI data. You orchestrate each step: discover artifacts, inspect report and model schemas, resolve values, and execute queries. Uses the FabricIQ MCP server.
| Task | Reference | Notes |
|---|---|---|
| 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 |
| Authentication Recipes | COMMON-CLI.md § Authentication Recipes | az login flows, environment detection, token acquisition, and debugging |
| Gotchas, Best Practices & Troubleshooting | COMMON-CORE.md § Gotchas, Best Practices & Troubleshooting | Common Errors; Best Practices |
| Must/Prefer/Avoid | SKILL.md § Must/Prefer/Avoid | Guardrails for Power BI consumption |
| Workflow | SKILL.md § Workflow | FabricIQ orchestration steps |
| Tool | Purpose |
|---|---|
DiscoverArtifacts(searchQuery, artifactTypes?, maxResults?) | Search for Power BI reports and semantic models by free text. Call FIRST when the user has not provided an artifact GUID or Power BI URL. Maximum 50 results. Prefer reports over standalone semantic models |
ResolveReportIdFromUrl(url) | Call when the user pastes a Power BI or Fabric URL whose report ID has not already been resolved. Required for workspace-App URLs (.../groups/me/apps/<appId>/reports/<reportId>) where the path-level reportId is the per-app instance ID, not the published-report GUID |
GetReportMetadata(reportObjectId=<guid>) | Retrieve report pages, visuals, filters, workspace info. Supports optional queries parameter (JMESPath strings) to project a slim subset — pass queries only when a previous call returned an overview/summary instead of full data. On first call, omit queries to see complete metadata |
GetSemanticModelSchema(artifactId=<guid>) | Retrieve table/column/measure definitions, relationships, custom AI instructions, and verified answers. Supports optional queries parameter (JMESPath). On first call, omit queries to see complete schema |
…
通过命令行分析 Fabric 数据仓库性能,定位慢查询与资源压力并给出优化建议。
通过只读 API 检查 Fabric 中现有告警、通知与自动化动作配置
检查 skills-for-fabric 技能集是否有更新,并展示版本差异与更新日志。
帮助你查询 Fabric Eventhouse 数据、分析时序趋势并监控摄取状态。
帮助你列出、解析并检查 Microsoft Fabric Eventstream 的拓扑与配置状态。
帮助你开发 Microsoft Fabric Spark 与数据工程流程,编写调试 Notebook 代码并管理湖仓资源。
用自然语言查询 Power BI 报表与仪表板,快速获得业务数据答案。
用自然语言查询 Power BI 报表与仪表板,快速获得业务数据答案
用于执行 DAX 查询并检查 Fabric Power BI 语义模型元数据。
执行 DAX 查询并检查 Power BI 语义模型元数据,快速获取表、列、度量与关系信息。
执行 Power BI 语义模型的原始 DAX 查询并检查模型元数据。
自动创建并填充 Power BI 仪表板,快速完成模板匹配与数据映射。