skills.rest
patrikborosch
patrikboroschCOMMUNITY
Explore all skills by this author →
GitHub

dataflows-consumption-cli

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
One-click install
npx skills add https://github.com/patrikborosch/AnalyticsPlatformAgents --skill dataflows-consumption-cli-patrikborosch
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
rritecrritec
3

dataflows-consumption-cli

Inspect Microsoft Fabric Dataflows Gen2 definitions, parameters, and refresh status from the command line.

Community
Advanced
Sampi314Sampi314
1

ag-pq-auditor

Audit Power Query M code from Excel workbooks or .m files for performance, security, and data quality issues.

Community
Advanced
thimsluggathimslugga

jq-json-processor

Filter, map, and transform JSON data using jq syntax.

Community
Intermediate
weiflycc-cmdweiflycc-cmd

eventhouse-consumption-cli

Execute read-only KQL queries against Microsoft Fabric Eventhouse via CLI.

Community
Intermediate