dataflows-consumption-cli

Name: dataflows-consumption-cli
Availability: InStock
Author: patrikborosch

Access Microsoft Fabric Dataflows Gen2 via CLI for monitoring and querying.

14|3|Updated Mar 13, 2026

Search Tags:#az cli #power query #read-only queries #fabric dataflows #dataflow monitoring #arrow ipc #dataflow inspection

Ready to run

npx skills add https://github.com/patrikborosch/AnalyticsPlatformAgents --skill dataflows-consumption-cli-patrikborosch

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: dataflows-consumption-cli
Source: https://github.com/patrikborosch/AnalyticsPlatformAgents/tree/main/creator/skills/dataflows-consumption-cli
Command: npx skills add https://github.com/patrikborosch/AnalyticsPlatformAgents --skill dataflows-consumption-cli-patrikborosch

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Users working with Microsoft Fabric Dataflows Gen2 often need to programmatically access dataflow definitions, monitor refresh status, and query data without navigating the web UI, which is time-consuming and difficult to automate for debugging, auditing, or data extraction tasks.

Core Features & Use Cases

Dataflow Discovery: List all dataflows across Fabric workspaces, filter by name, and retrieve dataflow properties.
Definition Inspection: Decode base64-encoded dataflow definitions to view Power Query M code, connection metadata, and query configurations.
Monitoring & Querying: Track refresh job history, discover dataflow parameters, and execute read-only queries against saved dataflows with Apache Arrow IPC result parsing.
Use Case: A data engineer can use this skill to quickly diagnose a failed dataflow refresh by inspecting its M code, checking error history, and pulling a sample of its output data without opening the Fabric UI.

Quick Start

Use the dataflows-consumption-cli skill to list all dataflows in your default Fabric workspace and display the recent refresh status for the Sales Data Pipeline dataflow.

Frequently Asked Questions about dataflows-consumption-cli

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I monitor Fabric Dataflows Gen2 refresh status without using the web UI?▼

You can monitor Fabric Dataflows Gen2 refresh status programmatically using az CLI. This approach tracks refresh job history and dataflow monitoring without the web UI, enabling automated checks for debugging and governance auditing.

Can I extract Power Query M code from a Fabric dataflow definition?▼

Yes, you can extract Power Query M code by decoding base64-encoded dataflow definitions. This reveals Power Query M code, connection metadata, and query configurations without relying on the Fabric web interface.

What's the best way to run read-only queries against saved Fabric dataflows?▼

The best way to run read-only queries against saved Fabric dataflows is via CLI tools. This executes ad-hoc or persisted read-only queries with Apache Arrow IPC result parsing, using az CLI, jq, and pyarrow.

Do I need az CLI to list dataflows across Fabric workspaces?▼

Yes, az CLI is required to list dataflows across Fabric workspaces. This discovers all workspace dataflows, filters by name, and retrieves dataflow properties for data extraction and inspection.

Does dataflow consumption via CLI support Apache Arrow IPC stream processing?▼

Yes, dataflow consumption via CLI supports Apache Arrow IPC stream processing. It uses pyarrow for Arrow stream processing to parse results from read-only queries executed against Fabric Dataflows Gen2.

Why does decoding a Fabric dataflow definition show base64 text instead of M code?▼

Decoding a Fabric dataflow definition shows base64 text because definitions are base64-encoded. You must decode the base64 definition to extract readable Power Query M code and connection metadata for inspection.