用自然语言查询 Power BI 报表与仪表板,快速获得业务数据答案。
复制安装指令,让 AI 自动完成配置 · 推荐新手
请帮我安装 askskill 上的 "fabriciq" 技能: 1. 下载 https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/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 |
…
扫描并评估 Power BI Gen1 数据流,生成迁移快照并执行升级为 Gen2.1 副本。
帮助你在 Microsoft Fabric 中搭建端到端青铜白银黄金湖仓分层与数据管道。
帮助将 Azure HDInsight 的 Spark、Hive 与 Oozie 工作负载迁移到 Microsoft Fabric。
跨工作区查找 Microsoft Fabric 项目并返回所属工作区与相关 ID。
帮助你创建、编辑、部署并优化 Power BI 语义模型与 DAX 性能。
帮助将 Databricks 笔记本、作业与数据路径系统迁移到 Microsoft Fabric。
用于执行 DAX 查询并检查 Fabric Power BI 语义模型元数据。
通过自然语言操控 Power BI,快速生成度量、解释指标并优化数据模型。
自动创建并填充 Power BI 仪表板,快速完成模板匹配与数据映射。
根据仪表盘截图与提示词自动生成 Power BI 的 .pbix 文件
快速生成含图表、筛选器与表格的可分享交互式 HTML 仪表盘。
通过自然语言连接 Power BI,查询工作区、运行 DAX 并刷新数据集。