skills.rest
microsoft
microsoftOFFICIAL
Explore all skills by this author →
Website𝕏@OpenAtMicrosoftGitHub

dataflows-consumption-cli

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

952|267|Updated Feb 17, 2026
Search Tags:#monitoring#cli#fabric#decode#consume#dataflows#executeQuery
One-click install
npx skills add https://github.com/microsoft/skills-for-fabric --skill dataflows-consumption-cli
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dataflows-consumption-cli
Source: https://github.com/microsoft/skills-for-fabric/tree/main/plugins/fabric-skills/skills/dataflows-consumption-cli
Command: npx skills add https://github.com/microsoft/skills-for-fabric --skill dataflows-consumption-cli

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill enables you to explore, monitor, and query saved Fabric Dataflows Gen2 using the read-only consumption CLI, reducing manual datawork.

Core Features & Use Cases

  • List dataflows in a workspace and view their properties.
  • Decode mashup.pq and inspect query metadata to understand connections, parameters, and staging rules.
  • Execute queries (persisted or ad-hoc) and monitor refresh history, with Arrow-based results and embedded error detection.
  • Use agentic exploration patterns to discover, parameterize, and monitor dataflows in production environments.

Quick Start

Install the dataflows-consumption-cli bundle and run a quick listing of dataflows in your workspace.

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 via CLI?▼

You can monitor Fabric Dataflows Gen2 refresh history via the CLI by executing read-only commands to retrieve refresh status. This skill uses az rest patterns to access and display refresh monitoring data.

Can I decode mashup.pq files from Dataflows Gen2 using command line?▼

Yes, you can decode mashup.pq files from Dataflows Gen2 using command line by handling the 202 getDefinition LRO pattern and decoding base64 parts. This reveals query metadata, connections, parameters, and staging rules.

How do I execute queries on Dataflows Gen2 and get Arrow results?▼

You can execute persisted or ad-hoc queries on Dataflows Gen2 and receive Arrow-based results. The CLI handles query execution and embeds error detection directly within the returned Arrow data format.

Do I need az login to access and list dataflows in a Fabric workspace?▼

Yes, you need az login authentication to access and list dataflows in a Fabric workspace. This prerequisite ensures secure credential handling while you discover, parameterize, and monitor dataflows across environments.

What are the limitations of using read-only consumption CLI for Dataflows Gen2?▼

The read-only consumption CLI for Dataflows Gen2 is limited to listing dataflows, inspecting definitions, monitoring refresh history, and executing queries. It does not modify dataflows and requires handling potential 202 LRO responses during definition retrieval.

Related Skills

Explore More Data & Analytics Skills→
wardawgmalviciouswardawgmalvicious
2

fabric-auth

Configure authentication tokens for Microsoft Fabric APIs with correct audiences.

Community
Intermediate
weirdgmeweirdgme
4

platform-engineering

Design and implement scalable platform engineering patterns for internal developer platforms.

Community
Advanced
markus41markus41
12

Fabric Data Factory

Automate end-to-end data integration and orchestration in Microsoft Fabric Data Factory.

Community
Advanced
rritecrritec
3

dataflows-authoring-cli

Manage Microsoft Fabric Dataflow Gen2 definitions via the Fabric REST API.

Community
Advanced