$ loading_
Ask natural-language questions about Power BI reports and get business answers.
Copy the install command and let the AI configure it · recommended for beginners
Please install the "fabriciq" skill from askskill: 1. Download https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/skills/fabriciq/SKILL.md 2. Save it as ~/.claude/skills/fabriciq/SKILL.md 3. Reload skills and tell me it's ready
Ask Power BI for the top 10 products by sales this quarter, list both revenue and units sold, and add a brief conclusion.
A ranked list of the top 10 products from report data, key metric comparisons, and a brief business summary.
Using the Power BI report, compare last month's sales performance across East, South, and North China, including revenue differences, growth rates, and anomalies.
A comparison of regional sales results, growth performance notes, and notable anomalies to investigate.
First discover the currently accessible Power BI reports and dashboards, then tell me which sales-analysis tables, fields, and measures are available to query.
An overview of accessible report assets and the relevant data structures available for follow-up questions.
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 |
…
Build end-to-end Bronze, Silver, and Gold lakehouse pipelines in Microsoft Fabric.
Create, update, and publish Microsoft Fabric Eventstream topologies via REST APIs.
Migrate HDInsight Spark, Hive, and Oozie workloads to Microsoft Fabric.
Search Microsoft Fabric items across workspaces and return locations and IDs.
Create, edit, deploy, and optimize Power BI semantic models and DAX.
Scan, assess, and upgrade Power BI Gen1 dataflows into Gen2.1 copies.
Discover Power BI assets, run DAX, and generate executive HTML reports.
Run DAX queries and inspect Fabric Power BI semantic model metadata.
Control Power BI with natural language to build measures and improve models.
Discover and connect Power BI workspaces and semantic models for data access.
Automatically build Power BI dashboards with template selection and data mapping.
Generate Power BI .pbix files from dashboard images and prompts.