Power BI Performance Expert Mode

Power BI Performance Expert Mode is an agent for Claude Code from archubbuck/workspace-architect. It costs 31 tokens per session (3,253 once invoked), scanned A, a copy of Power BI Performance Expert Mode, ISC.

A guide to finding and fixing performance problems in Power BI models, reports, and queries. It covers data retrieval, DAX calculations, visual rendering, capacity use, and DirectQuery connections.

In plain words
What is it for?
Use it to assess Power BI performance, optimise DAX and models, improve report interactions, tune DirectQuery use, and troubleshoot capacity problems.
Why use it?
It helps explain why reports load slowly, visuals respond poorly, or queries consume too many resources. It provides a structured way to identify bottlenecks and improve performance.

Agent for Claude Code

Written for Claude Code: a Claude Code subagent (agents/*.md). Also seen: model in frontmatter.

Good fit Use it to assess Power BI performance, optimise DAX and models, improve report interactions, tune DirectQuery use, and troubleshoot capacity problems.

Compare 6 agents from other repositories ↓
Install with agentmods
npx agentmods add agents/archubbuck/workspace-architect/power-bi-performance-expert
Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Clone the repo
git clone --depth 1 https://github.com/archubbuck/workspace-architect

Made for: Claude Code.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for Power BI Performance Expert Mode

README.md
[![agentmods](https://agentmods.dev/badge/agents/archubbuck/workspace-architect/power-bi-performance-expert.svg)](https://agentmods.dev/agents/archubbuck/workspace-architect/power-bi-performance-expert)
Your own site
<a href="https://agentmods.dev/agents/archubbuck/workspace-architect/power-bi-performance-expert"><img src="https://agentmods.dev/badge/agents/archubbuck/workspace-architect/power-bi-performance-expert.svg" alt="Measured on agentmods" height="20"></a>
Per session 31 Only the description is in the session, so the agent can decide to use it. The body loads when it is invoked.
When invoked 3,253 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin 100% copy Near-identical to another mod in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00031 $0.03253
Opus 5 $0.00015 $0.01626
Sonnet 5 $0.00006 $0.00651
Haiku 4.5 $0.00003 $0.00325

Measured 4d ago against content hash 2104eb028fcc, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-07, from the pricing page.

Security

Grade A, and why

Power BI Performance Expert Mode scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 4d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

Origin

This is a copy

100% identical to Power BI Performance Expert Mode — 0 lines differ, which has more behind it and is treated as the original. This page carries a canonical link to it rather than competing with it.

assets/agents/power-bi-performance-expert.agent.md · 555 lines

How it starts

The opening of the file, as written. The whole thing — 555 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Power BI Performance Expert Mode

You are in Power BI Performance Expert mode. Your task is to provide expert guidance on performance optimization, troubleshooting, and monitoring for Power BI solutions following Microsoft's official performance best practices.

Core Responsibilities

Always use Microsoft documentation tools (microsoft.docs.mcp) to search for the latest Power BI performance guidance and optimization techniques before providing recommendations. Query specific performance patterns, troubleshooting methods, and monitoring strategies to ensure recommendations align with current Microsoft guidance.

Performance Expertise Areas:

  • Query Performance: Optimizing DAX queries and data retrieval
  • Model Performance: Reducing model size and improving load times
  • Report Performance: Optimizing visual rendering and interactions
  • Capacity Management: Understanding and optimizing capacity utilization
  • DirectQuery Optimization: Maximizing performance with real-time connections
  • Troubleshooting: Identifying and resolving performance bottlenecks

Performance Analysis Framework

1. Performance Assessment Methodology

Performance Evaluation Process:

Step 1: Baseline Measurement
- Use Performance Analyzer in Power BI Desktop
- Record initial loading times
- Document current query durations
- Measure visual rendering times

Step 2: Bottleneck Identification
- Analyze query execution plans
- Review DAX formula efficiency
- Examine data source performance
- Check network and capacity constraints

Step 3: Optimization Implementation
- Apply targeted optimizations
- Measure improvement impact
- Validate functionality maintained
- Document changes made

Step 4: Continuous Monitoring
- Set up regular performance checks
- Monitor capacity metrics
- Track user experience indicators
- Plan for scaling requirements

2. Performance Monitoring Tools

Essential Tools for Performance Analysis:

Power BI Desktop:
- Performance Analyzer: Visual-level performance metrics
- Query Diagnostics: Power Query step analysis
- DAX Studio: Advanced DAX analysis and optimization

Power BI Service:
- Fabric Capacity Metrics App: Capacity utilization monitoring
- Usage Metrics: Report and dashboard usage patterns
- Admin Portal: Tenant-level performance insights

External Tools:
- SQL Server Profiler: Database query analysis
- Azure Monitor: Cloud resource monitoring
- Custom monitoring solutions for enterprise scenarios

Read the full file on GitHub · 555 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 4d ago First seen · 555 lines · 31 tokens per session scan A 2104eb028fcc

Subscribe to this mod's changes

Power BI Performance Expert Mode is an agent published in the GitHub repository archubbuck/workspace-architect (18 stars, last pushed 4d ago), licensed ISC. It adds 31 tokens to every session and 3,253 once invoked, about $0.0002 per session on Opus 5. A static security scan graded it A with 0 findings. It is 100% identical to Power BI Performance Expert Mode, differing in 0 lines, and is treated as a copy.

Related

Other agents, from other repositories

rca-debugger

Root-cause analyzer for complex multi-system failures — the third stage of the debugging escalation chain (build-error-resolver → systematic-debugger → rca-debugger → escalation-fixer). Escalation from systematic-debugger when the bisect is inconclusive, there is a CI-vs-local discrepancy, the bug is flaky, or the…

sangrokjung/claude-forge · 118 tokens

refactor-cleaner

An agent for finding and safely removing dead code, unused exports, unused dependencies, and duplicate implementations.

sangrokjung/claude-forge · 109 tokens

build-error-resolver

A focused agent for restoring a failed software build with the smallest practical code changes.

sangrokjung/claude-forge · 106 tokens

verify-agent

A fresh-context agent that checks completed code changes by running type checks, linting, builds, and tests. Fresh context means the checker did not write the change and can inspect it independently.

sangrokjung/claude-forge · 134 tokens

AL Debugging Specialist

AL Debugging specialist for Business Central. Expert in troubleshooting, root cause analysis, and resolving AL development issues using debugging tools and techniques.

javiarmesto/ALDC-AL-Development-Collection · 32 tokens

al-triage

Reactive diagnosis specialist for EXISTING Business Central AL code — reproduce, localize, root-cause, and recommend a minimal fix for bugs, regressions, and incidents. Read-only on code: produces a diagnosis and hands the fix to al-developer. The dynamic counterpart to dredd (static audit). Use when you start from a…

javiarmesto/ALDC-AL-Development-Collection · 90 tokens