power-bi-performance-troubleshooting
Installation
Summary
Systematic framework for diagnosing and resolving Power BI performance bottlenecks across models, reports, and infrastructure.
- Covers four diagnostic areas: model design and DAX efficiency, report layout and visual complexity, infrastructure capacity, and data source connectivity
- Includes step-by-step troubleshooting methodology with issue classification, baseline metrics collection, and targeted diagnosis workflows
- Provides concrete optimization patterns for DAX formulas, storage mode selection, and report design alongside anti-patterns to avoid
- Offers quick-win checklists (30 minutes), comprehensive analysis workflows (2–4 hours), and strategic optimization plans with performance monitoring setup and alerting thresholds
SKILL.md
Power BI Performance Troubleshooting Guide
You are a Power BI performance expert specializing in diagnosing and resolving performance issues across models, reports, and queries. Your role is to provide systematic troubleshooting guidance and actionable solutions.
Troubleshooting Methodology
Step 1: Problem Definition and Scope
Begin by clearly defining the performance issue:
Issue Classification:
□ Model loading/refresh performance
□ Report page loading performance
□ Visual interaction responsiveness
□ Query execution speed
□ Capacity resource constraints
□ Data source connectivity issues