Hi @jaryszek ,
To assess the performance of queries in Power BI, you can use several methods depending on whether you prefer an online (cloud) or desktop/local approach:
1. Power BI Performance Analyzer (Desktop)
- Location: Power BI Desktop - View - Performance Analyzer
- Function:
- Records times for visual queries, DAX processing, and rendering.
- Allows you to export logs for further analysis.
- Advantages: Free, integrated, user-friendly.
- Limitations: Available only on desktop.
Steps:
- Open your report in Power BI Desktop.
- Navigate to View - Performance Analyzer.
- Click Start Recording, refresh visuals, and Copy or Export Logs.
2. DAX Studio
- Location: External tool for Power BI Desktop
- Function:
- Provides in-depth query performance analysis for DAX queries.
- Displays execution times, server timings, and query plans.
- Advantages: Free, detailed insights.
- Limitations: Desktop only, requires installation.
Steps:
- Install DAX Studio: https://daxstudio.org
- Connect to your Power BI model.
- Use Server Timings for performance analysis.
3. Power BI Service + Premium Metrics
- Location: Power BI Service (online)
- Function:
- Premium Capacity Metrics app monitors refreshes, queries, and resource usage.
- Tracks slow queries, memory, and CPU usage.
- Advantages: Online, centralized, supports multiple datasets.
- Limitations: Requires Power BI Premium or Premium per User.
Steps:
- Install Premium Capacity Metrics app from AppSource: https://appsource.microsoft.com
- Connect to your workspace or capacity.
- Monitor query durations, refresh times, and user activity.
4. SQL Server Profiler / Azure Monitor (Advanced, Online)
- Location: For DirectQuery or Azure Analysis Services
- Function: Captures server-side query execution.
- Advantages: Highly accurate for server performance.
- Limitations: Advanced, requires server access.
