# Powerbi Cost Capacity Optimizer

> Optimize Power BI and Fabric cost, capacity, refresh load, dataset size, DirectQuery pressure, workspace sprawl, Premium/Fabric capacity usage, and unused assets.

- Skill: `rweisssieker-xp/powerbi-cost-capacity-optimizer` (Agent Skill)
- Install (CLI): `npx skillmds@latest add rweisssieker-xp/powerbi-cost-capacity-optimizer`
- Raw SKILL.md: https://api.skillmd.com/api/skills/rweisssieker-xp/powerbi-cost-capacity-optimizer/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: AI & ML
- Author: rweisssieker-xp (https://skillmd.com/u/rweisssieker-xp)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/rweisssieker-xp/powerbi-cost-capacity-optimizer

---


# 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.