powerbi-cost-capacity-optimizer

name	powerbi-cost-capacity-optimizer
description	Optimize Power BI and Fabric cost, capacity, refresh load, dataset size, DirectQuery pressure, workspace sprawl, Premium/Fabric capacity usage, and unused assets.

Power BI Cost and Capacity Optimizer

Use this skill when reducing operational cost is part of reducing Power BI expert load.

Analysis Areas

• Capacity: CPU, memory, throttling, refresh concurrency, visual query load.
• Storage: dataset/model size, duplicate imports, unused columns, incremental refresh, retention.
• Workspaces: inactive reports, duplicate semantic models, abandoned dataflows, owner gaps.
• Architecture: import vs DirectQuery vs Direct Lake, aggregation tables, certified datasets.
• Licensing: Pro, PPU, Premium, Fabric capacity, external sharing needs.

Output Requirements

• Produce savings opportunities with risk, owner, effort, expected benefit, and verification metric.
• Do not recommend deletion without owner approval and retention review.