skills.rest
PatrickGallucci
PatrickGallucciCOMMUNITY
Explore all skills by this author →
GitHub

fabric-dataflows-perf-remediation

Diagnose and remediate Dataflow Gen2 performance issues across Fabric workspaces.

16|1|Updated Feb 10, 2026
Search Tags:#performance#monitoring#diagnostics#powershell#dataflow-gen2#dataflows
One-click install
npx skills add https://github.com/PatrickGallucci/fabric-skills --skill fabric-dataflows-perf-remediation
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: fabric-dataflows-perf-remediation
Source: https://github.com/PatrickGallucci/fabric-skills/tree/main/skills/fabric-dataflows-perf-remediate
Command: npx skills add https://github.com/PatrickGallucci/fabric-skills --skill fabric-dataflows-perf-remediation

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires Az.Accounts, and includes scripts (resource) and references (resource) components.

What problem does it solve?

Data engineers and operators struggle with slow Dataflow Gen2 refreshes, inefficient staging, and capacity throttling across Fabric workspaces. This skill provides structured diagnostic workflows, actionable insights, and automation to identify bottlenecks and drive performance improvements.

Core Features & Use Cases

  • Comprehensive diagnostic workflows to analyze refresh history, per-table timing, and destination write performance across Dataflow Gen2 workloads.
  • Automates health auditing and real-time monitoring via Get-DataflowHealthReport.ps1 and Watch-DataflowRefresh.ps1 scripts.
  • Access guidance from the Performance Optimization Guide and REST API references to implement fast-copy patterns, staging strategies, and query folding optimizations.
  • Use Case: Quickly locate and remediate a Dataflow Gen2 refresh that intermittently fails under load in a Fabric workspace.

Quick Start

Run the Get-DataflowHealthReport.ps1 script for a workspace health audit and, optionally, the Watch-DataflowRefresh.ps1 script for real-time monitoring.

Frequently Asked Questions about fabric-dataflows-perf-remediation

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

FAQPage Schema
How do I diagnose slow Dataflow Gen2 refreshes in Fabric workspaces?▼

Diagnose slow Dataflow Gen2 refreshes by running the Get-DataflowHealthReport.ps1 script. It audits workspace health, analyzes refresh history, and identifies staging bottlenecks or destination write performance issues.

What causes capacity throttling and staging bottlenecks in Dataflow Gen2?▼

Capacity throttling and staging bottlenecks in Dataflow Gen2 occur from inefficient query folding, gateway latency, and heavy refresh loads. Use structured diagnostic workflows to analyze these factors and apply Fast Copy patterns for optimization.

Do I need PowerShell and the Az.Accounts module to monitor Dataflow Gen2 performance?▼

Yes, monitoring Dataflow Gen2 performance requires PowerShell 7+ and the Az.Accounts module. These dependencies are necessary to run health auditing scripts and authenticate with the Fabric REST API for real-time refresh monitoring.

How do I monitor real-time Dataflow Gen2 refresh performance?▼

Monitor Dataflow Gen2 refresh performance in real time by running the Watch-DataflowRefresh.ps1 script. This automation tracks active refreshes, captures gateway latency metrics, and alerts on capacity throttling conditions.

When should I enable Fast Copy or adjust query folding in Dataflow Gen2?▼

Enable Fast Copy in Dataflow Gen2 when dealing with large data volumes to improve staging throughput. Adjust query folding when native data source transformations are possible to minimize data movement and reduce refresh times.

What's the best way to troubleshoot a Dataflow Gen2 refresh that intermittently fails under load?▼

Troubleshoot a Dataflow Gen2 refresh failing under load by executing a comprehensive health audit. Use diagnostic scripts to review refresh history, correlate capacity throttling events, and identify gateway latency spikes during peak utilization.

Related Skills

Explore More Data & Analytics Skills→
weiflycc-cmdweiflycc-cmd

spark-operations-cli

Diagnose failed Spark jobs and Livy sessions in Microsoft Fabric via read-only CLI.

Community
Advanced
PatrickGallucciPatrickGallucci
16

fabric-data-factory-perf-remediate

Diagnose and remediate Microsoft Fabric Data Factory pipeline performance issues.

Community
Advanced
patrikboroschpatrikborosch
14

dataflows-consumption-cli

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

Community
Advanced
PatrickGallucciPatrickGallucci
16

fabric-rti-perf-remediate

Diagnose and remediate Fabric RTI performance issues across Eventhouse, KQL databases, Eventstream, and ingestion pipelines.

Community
Advanced