• Identify slowest visuals and operations
• Compare DAX query vs. visual rendering time
• Export results for detailed analysis

Usage:

1. Open Performance Analyzer pane
2. Start recording
3. Refresh visuals or interact with report
4. Analyze results by duration
5. Focus on highest duration items first

### **DAX Studio Analysis**

Advanced DAX Analysis:

• Query execution plans
• Storage engine vs. formula engine usage
• Memory consumption patterns
• Query performance metrics
• Server timings analysis

Key Metrics to Monitor:

• Total duration
• Formula engine duration
• Storage engine duration
• Scan count and efficiency
• Memory usage patterns

### **Capacity Monitoring**

Fabric Capacity Metrics App:

• CPU and memory utilization trends
• Query volume and patterns
• Refresh performance tracking
• User activity analysis
• Resource bottleneck identification

Premium Capacity Monitoring:

• Capacity utilization dashboards
• Performance threshold alerts
• Historical trend analysis
• Workload distribution assessment

## Solution Framework

### **Immediate Performance Fixes**

#### Model Optimization:
```dax
-- Replace inefficient patterns:

❌ Poor Performance:
Sales Growth = 
([Total Sales] - CALCULATE([Total Sales], PREVIOUSMONTH('Date'[Date]))) / 
CALCULATE([Total Sales], PREVIOUSMONTH('Date'[Date]))

✅ Optimized Version:
Sales Growth = 
VAR CurrentMonth = [Total Sales]
VAR PreviousMonth = CALCULATE([Total Sales], PREVIOUSMONTH('Date'[Date]))
RETURN
    DIVIDE(CurrentMonth - PreviousMonth, PreviousMonth)

Report Optimization:

• Reduce visuals per page to 6-8 maximum
• Implement drill-through instead of showing all details
• Use bookmarks for different views instead of multiple visuals
• Apply filters early to reduce data volume
• Optimize slicer selections and cross-filtering

Data Model Optimization:

• Remove unused columns and tables
• Optimize data types (integers vs. text, dates vs. datetime)
• Replace calculated columns with measures where possible
• Implement proper star schema relationships
• Use incremental refresh for large datasets

Advanced Performance Solutions

Storage Mode Optimization:

Import Mode Optimization:
- Data reduction techniques
- Pre-aggregation strategies
- Incremental refresh implementation
- Compression optimization

DirectQuery Optimization:
- Database index optimization
- Query folding maximization
- Aggregation table implementation
- Connection pooling configuration

Composite Model Strategy:
- Strategic storage mode selection
- Cross-source relationship optimization
- Dual mode dimension implementation
- Performance monitoring setup

Infrastructure Scaling:

Capacity Scaling Considerations:
- Vertical scaling (more powerful capacity)
- Horizontal scaling (distributed workload)
- Geographic distribution optimization
- Load balancing implementation

Gateway Optimization:
- Dedicated gateway clusters
- Load balancing configuration
- Connection optimization
- Performance monitoring setup

Troubleshooting Workflows

Quick Win Checklist (30 minutes)

□ Check Performance Analyzer for obvious bottlenecks
□ Reduce number of visuals on slow-loading pages
□ Apply default filters to reduce data volume
□ Disable unnecessary cross-filtering
□ Check for missing relationships causing cross-joins
□ Verify appropriate storage modes
□ Review and optimize top 3 slowest DAX measures

Comprehensive Analysis (2-4 hours)

□ Complete model architecture review
□ DAX optimization using variables and efficient patterns
□ Report design optimization and restructuring
□ Data source performance analysis
□ Capacity utilization assessment
□ User access pattern analysis
□ Mobile performance testing
□ Load testing with realistic concurrent users

Strategic Optimization (1-2 weeks)

□ Complete data model redesign if necessary
□ Implementation of aggregation strategies
□ Infrastructure scaling planning
□ Monitoring and alerting setup
□ User training on efficient usage patterns
□ Performance governance implementation
□ Continuous monitoring and optimization process

Performance Monitoring Setup

Proactive Monitoring

Key Performance Indicators:
- Average page load time by report
- Query execution time percentiles
- Model refresh duration trends
- Capacity utilization patterns
- User adoption and usage metrics
- Error rates and timeout occurrences

Alerting Thresholds:
- Page load time >15 seconds
- Query execution time >45 seconds
- Capacity CPU >80% for >10 minutes
- Memory utilization >90%
- Refresh failures
- High error rates

Regular Health Checks

Weekly:
□ Review performance dashboards
□ Check capacity utilization trends
□ Monitor slow-running queries
□ Review user feedback and issues

Monthly:
□ Comprehensive performance analysis
□ Model optimization opportunities
□ Capacity planning review
□ User training needs assessment

Quarterly:
□ Strategic performance review
□ Technology updates and optimizations
□ Scaling requirements assessment
□ Performance governance updates

Communication and Documentation

Issue Reporting Template

Performance Issue Report:

Issue Description:
- What specific performance problem is occurring?
- When does it happen (always, specific times, certain conditions)?
- Who is affected (all users, specific groups, particular reports)?

Performance Metrics:
- Current performance measurements
- Expected performance targets
- Comparison with previous performance

Environment Details:
- Report/model names affected
- User locations and network conditions
- Browser and device information
- Capacity and infrastructure details

Impact Assessment:
- Business impact and urgency
- Number of users affected
- Critical business processes impacted
- Workarounds currently in use

Resolution Documentation

Solution Summary:
- Root cause analysis results
- Optimization changes implemented
- Performance improvement achieved
- Validation and testing completed

Implementation Details:
- Step-by-step changes made
- Configuration modifications
- Code changes (DAX, model design)
- Infrastructure adjustments

Results and Follow-up:
- Before/after performance metrics
- User feedback and validation
- Monitoring setup for ongoing health
- Recommendations for similar issues

---

Usage Instructions: Provide details about your specific Power BI performance issue, including:

• Symptoms and impact description
• Current performance metrics
• Environment and configuration details
• Previous troubleshooting attempts
• Business requirements and constraints

I'll guide you through systematic diagnosis and provide specific, actionable solutions tailored to your situation.