fabriciq

用自然语言查询 Power BI 报表与仪表板，快速获得业务数据答案

来源

GitHub

更新于

2026-06-07

// 安全评估低风险

仅提示词，不执行代码
开源可审计

正在进行安全审计…

凭证密钥
网络外发
代码执行
数据访问
来源供应链

// 安装

复制安装指令，让 AI 自动完成配置 · 推荐新手

请帮我安装 askskill 上的 "fabriciq" 技能：
1. 下载 https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/plugins/fabric-consumption/skills/fabriciq/SKILL.md
2. 保存为 ~/.claude/skills/fabriciq/SKILL.md
3. 装好后重载技能，告诉我可以用了

// 下载

下载 SKILL.md机读安装清单 ↗

// 用法示例

查询热销产品

输入

请查询 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-updates skill.

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 DiscoverArtifacts with the search term — do not call workspace/item list APIs

To find the semantic model behind a report: call GetReportMetadata and extract the model GUID from the response

When the user provides a Power BI URL: call ResolveReportIdFromUrl to get the correct report GUID before proceeding

Power BI Consumption — FabricIQ Skill

⚠️ 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

Available Tools

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