What problem does it solve?
Manually managing Fabric Dataflows Gen2 artifacts through the web UI or raw API calls is time-consuming and error-prone, especially for teams that need to automate ETL pipeline changes, deploy across environments, or trigger refreshes programmatically. This Skill eliminates that overhead by providing structured, CLI-based workflows for all common Dataflows Gen2 authoring and management tasks.
Core Features & Use Cases
- Full CRUD Lifecycle: Create, update, retrieve, and delete Dataflows Gen2 artifacts, including full management of definition parts (Power Query M mashup code, query metadata, and platform properties).
- Job Execution & Monitoring: Trigger dataflow refresh jobs with optional parameter overrides, and poll long-running operations to track completion status and handle failures.
- CI/CD Integration: Export dataflow definitions for version control and import them across development, test, and production environments to support automated deployment pipelines.
- Real-World Use Case: A data engineer can use this Skill to update Power Query M queries for a sales dataflow, deploy the change to a production workspace, and trigger a refresh with environment-specific parameters in minutes, without manual UI edits.
Quick Start
Use the dataflows-authoring-cli skill to create a new Fabric Dataflow Gen2 with custom Power Query M queries and trigger a refresh job for it.