$ loading_
Monitor, inspect, and query Fabric Dataflows Gen2 through a read-only CLI.
Copy the install command and let the AI configure it · recommended for beginners
Please install the "dataflows-consumption-cli" skill from askskill: 1. Download https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/skills/dataflows-consumption-cli/SKILL.md 2. Save it as ~/.claude/skills/dataflows-consumption-cli/SKILL.md 3. Reload skills and tell me it's ready
List Fabric Dataflows Gen2 dataflows in the workspace, then decode the specified dataflow definition and summarize mashup.pq, queryMetadata.json, .platform, and all available parameters.
Returns the dataflow list, decoded definition summaries, and parameter names, types, and purposes.
Get the latest refresh status, last 10 refresh events, and related job history for this dataflow, highlighting failures, durations, and error messages.
Outputs the latest refresh result, a history table, and key diagnostics for failed jobs.
Execute read queries against the specified dataflow: first run a persisted query by QueryName and parse the Arrow IPC result, then run a read-only ad-hoc customMashupDocument and return the first 20 rows.
Returns parsed result tables with query source, schema details, and row counts.
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 a dataflow by name: list all dataflows in the workspace and filter by
displayNameclient-side — there is no server-side name filtergetDefinitionis a POST, not GET — even though it reads data
| Task | Reference | Notes |
|---|---|---|
| Finding Workspaces and Items in Fabric | COMMON-CLI.md § Finding Workspaces and Items in Fabric | Mandatory — READ link first |
| Fabric Topology & Key Concepts | COMMON-CORE.md § Fabric Topology & Key Concepts | |
| Environment URLs | COMMON-CORE.md § Environment URLs | |
| Authentication & Token Acquisition | COMMON-CORE.md § Authentication & Token Acquisition | Wrong audience = 401; read before any auth issue |
| Core Control-Plane REST APIs | COMMON-CORE.md § Core Control-Plane REST APIs | Includes pagination, LRO polling, and rate-limiting patterns |
| Job Execution | COMMON-CORE.md § Job Execution | |
| Gotchas, Best Practices & Troubleshooting | COMMON-CORE.md § Gotchas, Best Practices & Troubleshooting | |
| Tool Selection Rationale | COMMON-CLI.md § Tool Selection Rationale | |
| Authentication Recipes | COMMON-CLI.md § Authentication Recipes | az login flows and token acquisition |
Fabric Control-Plane API via az rest | COMMON-CLI.md § Fabric Control-Plane API via az rest | Always pass --resource; includes pagination and LRO helpers |
| Job Execution (CLI) | COMMON-CLI.md § Job Execution | |
| Gotchas & Troubleshooting (CLI-Specific) | COMMON-CLI.md § Gotchas & Troubleshooting (CLI-Specific) | az rest audience, shell escaping, token expiry |
| Quick Reference | COMMON-CLI.md § Quick Reference | az rest template + token audience/tool matrix |
| Consumption Capability Matrix | DATAFLOWS-CONSUMPTION-CORE.md § Consumption Capability Matrix | Read first — shows what ops are available |
| REST API Surface (Consumption) | DATAFLOWS-CONSUMPTION-CORE.md § REST API Surface | List, Get, Parameters, getDefinition, Jobs |
| Dataflow Definition Exploration | DATAFLOWS-CONSUMPTION-CORE.md § Dataflow Definition Exploration | Decode mashup.pq, queryMetadata.json, .platform |
| Parameter Discovery and Analysis | DATAFLOWS-CONSUMPTION-CORE.md § Parameter Discovery and Analysis | Types, formats, M code patterns |
…
Run authoring T-SQL for Fabric warehouses and SQL endpoints from CLI.
Migrate Databricks notebooks, jobs, and paths into Microsoft Fabric.
Query Fabric Eventhouse data, analyze time series, and monitor ingestion health.
Inspect Fabric alerts, notifications, and automated actions via read-only API calls.
List, inspect, and validate Microsoft Fabric Eventstream topology and configuration.
Ask natural-language questions about Power BI reports and get business answers.
Author and manage Fabric Dataflows Gen2 with preview and refresh via CLI.
Scan, assess, and upgrade Power BI Gen1 dataflows into Gen2.1 copies.
Run read-only T-SQL queries on Fabric warehouse and lakehouse data.
Analyze Fabric warehouse performance via CLI and get optimization recommendations.
Run DAX queries and inspect Fabric Power BI semantic model metadata.
Connect to Flowise to manage flows, run predictions, and automate analysis.