skills.rest
weiflycc-cmd
weiflycc-cmdCOMMUNITY
Explore all skills by this author →
GitHub

dataflows-consumption-cli

Inspect Fabric Dataflows Gen2 metadata, definitions, and refresh history via CLI.

Updated Jun 1, 2026
Search Tags:#data engineering#az cli#power query#microsoft fabric#dataflows#refresh monitoring#definition inspection
One-click install
npx skills add https://github.com/weiflycc-cmd/skills-for-fabric --skill dataflows-consumption-cli-weiflycc-cmd
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dataflows-consumption-cli
Source: https://github.com/weiflycc-cmd/skills-for-fabric/tree/main/plugins/fabric-skills/skills/dataflows-consumption-cli
Command: npx skills add https://github.com/weiflycc-cmd/skills-for-fabric --skill dataflows-consumption-cli-weiflycc-cmd

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill eliminates the need to manually navigate the Fabric web UI to access dataflow metadata, definitions, and refresh history, enabling fast, scriptable read-only inspection of Dataflows Gen2 directly from the CLI.

Core Features & Use Cases

  • Read-Only Dataflow Exploration: List all dataflows across workspaces, inspect item properties, and decode base64-encoded definitions to view Power Query M mashup code, query metadata, and connection bindings.
  • Parameter and Job Monitoring: Discover typed dataflow parameters with default values, poll refresh operations for real-time status, and retrieve detailed job history with timing and error details for troubleshooting.
  • Use Case: A data engineer can use this Skill to quickly diagnose a failed dataflow refresh by pulling job error logs and inspecting the underlying Power Query code for misconfigurations, all without switching to the Fabric UI.

Quick Start

Use the dataflows-consumption-cli skill to list all dataflows in your default Fabric workspace, decode the Power Query M code for the 'Sales Data Pipeline' dataflow, and check its latest refresh job status for errors.

Frequently Asked Questions about dataflows-consumption-cli

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

FAQPage Schema
How do I inspect Fabric Dataflows Gen2 definitions from the command line?▼

You can inspect Fabric Dataflows Gen2 definitions using CLI tools to retrieve metadata and decode base64-encoded parts. This allows you to view Power Query M mashup code, query metadata, and connection bindings without accessing the Fabric web UI.

Can I monitor Dataflows Gen2 refresh history without using the Fabric web UI?▼

Yes, you can monitor Dataflows Gen2 refresh history without the Fabric web UI by polling refresh operations via the CLI. This scriptable approach retrieves detailed job history, including execution status, timing, and error details for troubleshooting.

How do I extract Power Query M mashup code using az CLI?▼

To extract Power Query M mashup code using az CLI, you retrieve the dataflow definition and decode its base64-encoded parts. This exposes the underlying query metadata, typed parameters, and connection bindings for scriptable inspection.

What's the best way to troubleshoot a failed dataflow refresh in Microsoft Fabric?▼

The best way to troubleshoot a failed dataflow refresh in Microsoft Fabric is to pull detailed job history and error logs via CLI. You can simultaneously inspect the underlying Power Query code for misconfigurations without switching to the Fabric UI.

Do I need jq and base64 tools to read Dataflows Gen2 metadata?▼

Yes, you need jq and base64 tools to read Dataflows Gen2 metadata effectively. jq parses the JSON responses from the Fabric REST APIs, while base64 decoding is required to parse definition parts and view the actual Power Query M code.

Related Skills

Explore More Data & Analytics Skills→
microsoftmicrosoft
952

dataflows-consumption-cli

List Fabric Dataflows Gen2, decode mashup.pq, and execute queries with Arrow results.

Official
Advanced
weiflycc-cmdweiflycc-cmd

dataflows-authoring-cli

Automate Fabric Dataflows Gen2 CRUD and refresh jobs via CLI.

Community
Advanced
patrikboroschpatrikborosch
14

dataflows-consumption-cli

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

Community
Advanced
weiflycc-cmdweiflycc-cmd

powerbi-authoring-cli

Automate Power BI semantic model lifecycle in Fabric workspaces via Azure CLI REST API calls.

Community
Advanced