dataflows-authoring-cli

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

3|6|Updated Jun 21, 2024
One-click install
npx skills add https://github.com/rritec/Microsoft-Fabric --skill dataflows-authoring-cli-rritec
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dataflows-authoring-cli
Source: https://github.com/rritec/Microsoft-Fabric/tree/main/skills/plugins/fabric-authoring/skills/dataflows-authoring-cli
Command: npx skills add https://github.com/rritec/Microsoft-Fabric --skill dataflows-authoring-cli-rritec

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

It removes the manual complexity of creating and maintaining Microsoft Fabric Dataflows Gen2 by turning connection setup, mashup authoring, definition updates, preview checks, and refresh execution into a guided workflow.

Core Features & Use Cases

  • End-to-end dataflow authoring: Create, update, delete, and refresh Fabric Dataflows Gen2 through the Fabric REST API and CLI.
  • Power Query M preview loop: Validate candidate mashup logic before saving so syntax, schema, and credential issues are caught early.
  • Connection lifecycle management: Discover, create, inspect, test, and bind Fabric connections, including ClusterId resolution and composite connection IDs.
  • Destination publishing: Configure output destinations for Lakehouse, Warehouse, Azure Data Explorer, and Azure SQL targets.
  • Operational safety: Handles full-definition replacement, base64-encoded parts, long-running operations, and refresh verification for production workflows.

Quick Start

Ask the assistant to create, preview, update, bind, or refresh a Microsoft Fabric Dataflow Gen2 by providing the workspace, dataflow, source, and destination details.

Frequently Asked Questions about dataflows-authoring-cli

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

FAQPage Schema
How do I create and update Microsoft Fabric Dataflows Gen2 through the REST API?

You can create and update Microsoft Fabric Dataflows Gen2 by using the Fabric REST API to manage base64-encoded definitions, bind connections, configure output destinations, and verify refresh execution. This workflow handles full-definition replacement and long-running operations.

Can I preview Power Query M mashup logic before saving a Fabric dataflow?

Yes, you can preview Power Query M mashup logic before saving a Fabric dataflow. The preview loop validates candidate mashup logic early to catch syntax, schema, and credential issues before committing definition updates to the workspace.

What's the best way to automate Fabric dataflow refresh and connection binding?

Automate Fabric dataflow refresh and connection binding by using Azure CLI, jq, and curl to interact with the Fabric REST API. This approach handles ClusterId resolution, composite connection IDs, refresh execution, and refresh verification for production workflows.

Do I need Azure CLI and jq to manage Fabric dataflow definitions?

Yes, you need Azure CLI, jq, curl, and base64 handling to manage Fabric dataflow definitions. These tools are required to interact with the Fabric REST API, process base64-encoded definition parts, and handle long-running operations.

Does this approach support configuring output destinations like Lakehouse and Azure SQL?

Yes, this approach supports configuring output destinations for Lakehouse, Warehouse, Azure Data Explorer, and Azure SQL targets. Destination publishing is handled as part of the end-to-end dataflow authoring workflow.

Why does updating a Fabric dataflow require handling base64-encoded parts?

Updating a Fabric dataflow requires handling base64-encoded parts because the Fabric REST API transmits full definition replacements in base64 format. This ensures safe transport of Power Query M mashup logic and connection bindings during operations.