$ loading_
Run DAX queries and inspect Fabric Power BI semantic model metadata.
Copy the install command and let the AI configure it · recommended for beginners
Please install the "semantic-model-consumption" skill from askskill: 1. Download https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/skills/semantic-model-consumption/SKILL.md 2. Save it as ~/.claude/skills/semantic-model-consumption/SKILL.md 3. Reload skills and tell me it's ready
Run the following DAX query against the specified Microsoft Fabric Power BI semantic model: EVALUATE TOPN(10, 'Sales') Return the result table.
A result table from the DAX query showing the top 10 rows from Sales.
Use INFO functions to inspect this semantic model's metadata and list all table names; if possible, run a query similar to INFO.VIEW.TABLES and return the results.
A list of tables in the model with relevant metadata fields.
Inspect the semantic model's measure metadata, list all measures, and return the expression definition and parent table for a specified measure.
A list of measures plus the target measure's DAX expression and parent table information.
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 |
…
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.
Ask natural-language questions about Power BI reports and get business answers.
Query Microsoft Fabric workspaces, lakehouses, tables, jobs, and dependencies in natural language.
Control Power BI with natural language to build measures and improve models.
Run read-only T-SQL queries on Fabric warehouse and lakehouse data.
Discover and connect Power BI workspaces and semantic models for data access.