skills.rest
miyake-san
miyake-sanCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

power-bi-performance-troubleshooting

Diagnose and resolve performance issues in Power BI models, reports, and DAX queries.

Updated Aug 28, 2026
Search Tags:#data modeling#power bi#directquery#dax optimization#performance troubleshooting#capacity monitoring#report optimization
One-click install
npx skills add https://github.com/miyake-san/sogo-agent-platform --skill power-bi-performance-troubleshooting-miyake-san
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: power-bi-performance-troubleshooting
Source: https://github.com/miyake-san/sogo-agent-platform/tree/main/skills/domain/power-bi-performance-troubleshooting
Command: npx skills add https://github.com/miyake-san/sogo-agent-platform --skill power-bi-performance-troubleshooting-miyake-san

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Power BI reports and models often suffer from slow page loads, sluggish visual interactions, and long refresh times, and finding the root cause across models, DAX formulas, report design, and capacity infrastructure is difficult without a systematic approach. ## Core Features & Use Cases - Systematic Diagnostic Framework: Step-by-step methodology covering model design, DAX performance, report layout, and capacity/infrastructure bottlenecks. - Tool-Guided Analysis: Instructions for using Performance Analyzer, DAX Studio, and Fabric Capacity Metrics to collect baselines and pinpoint slow queries. - Actionable Fix Patterns: Concrete DAX rewrites (e.g., replacing repeated calculations with variables), report optimization rules, and storage mode strategies for Import, DirectQuery, and composite models. - Use Case: A report page takes 30 seconds to load. Use this Skill to run Performance Analyzer, identify the slowest visual, rewrite its inefficient DAX measure with variables, and reduce page load time under 10 seconds. ## Quick Start Ask the assistant to troubleshoot your slow Power BI report by describing the symptoms, affected reports, current load times, and environment details.

Frequently Asked Questions about power-bi-performance-troubleshooting

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I troubleshoot slow Power BI report performance?▼

Start with Performance Analyzer in Power BI Desktop to record visual refresh times and identify the slowest visuals. Then separate DAX query time from rendering time, reduce visuals per page to 6-8, and optimize the slowest DAX measures using variables.

How to optimize slow DAX measures in Power BI?▼

Rewrite measures using variables to avoid repeated calculations, avoid FILTER() as a filter argument, and minimize nested CALCULATE functions. Use DAX Studio to compare storage engine versus formula engine time and verify improvements.

What tools can I use to analyze Power BI query performance?▼

Use Performance Analyzer in Power BI Desktop for visual-level timings, DAX Studio for query execution plans and server timings, and the Fabric Capacity Metrics app for CPU, memory, and query volume monitoring.

Does DirectQuery mode affect Power BI report speed?▼

Yes, DirectQuery sends queries to the source database at interaction time, so speed depends on database indexing, query folding, and network latency. Aggregation tables, composite models, and dual-mode dimensions can reduce this overhead.

Why is my Power BI report page loading slowly?▼

Common causes include too many visuals per page, high-cardinality slicers, inefficient DAX measures, missing relationships causing cross-joins, and capacity CPU or memory pressure. Check Performance Analyzer first to isolate the bottleneck.

When should I use Import mode instead of DirectQuery?▼

Use Import mode when data volumes fit in memory and fast interactive performance is required, since the VertiPaq engine caches and compresses data. Choose DirectQuery only for very large datasets or near-real-time requirements.

Related Skills

Explore More Data & Analytics Skills→
lettucebolettucebo

power-bi-performance-troubleshooting

Diagnose and resolve performance issues in Power BI models, reports, and DAX queries.

Community
Intermediate
vecearvecear

db-performance-watchlist

Monitor slow queries, connections, resource usage, and index efficiency in production databases.

Community
Advanced
lettucebolettucebo

power-bi-model-design-review

Reviews Power BI data model architecture, relationships, and performance against best practices.

Community
Intermediate
HenderOrlandoHenderOrlando

data-platform

Design scalable data warehouses and lakehouses with star modeling and incremental loads.

Community
Advanced