power-bi-performance-troubleshooting
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
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
Scope Assessment:
More from github/awesome-copilot
git-commit
Execute git commit with conventional commit message analysis, intelligent staging, and message generation. Use when user asks to commit changes, create a git commit, or mentions "/commit". Supports: (1) Auto-detecting type and scope from changes, (2) Generating conventional commit messages from diff, (3) Interactive commit with optional type/scope/description overrides, (4) Intelligent file staging for logical grouping
30.2Kgh-cli
GitHub CLI (gh) comprehensive reference for repositories, issues, pull requests, Actions, projects, releases, gists, codespaces, organizations, extensions, and all GitHub operations from the command line.
21.2Kprd
Generate high-quality Product Requirements Documents (PRDs) for software systems and AI-powered features. Includes executive summaries, user stories, technical specifications, and risk analysis.
17.4Kdocumentation-writer
Diátaxis Documentation Expert. An expert technical writer specializing in creating high-quality software documentation, guided by the principles and structure of the Diátaxis technical documentation authoring framework.
17.4Kexcalidraw-diagram-generator
Generate Excalidraw diagrams from natural language descriptions. Use when asked to "create a diagram", "make a flowchart", "visualize a process", "draw a system architecture", "create a mind map", or "generate an Excalidraw file". Supports flowcharts, relationship diagrams, mind maps, and system architecture diagrams. Outputs .excalidraw JSON files that can be opened directly in Excalidraw.
16.4Krefactor
Surgical code refactoring to improve maintainability without changing behavior. Covers extracting functions, renaming variables, breaking down god functions, improving type safety, eliminating code smells, and applying design patterns. Less drastic than repo-rebuilder; use for gradual improvements.
16.1K