powerbi-optimization

powerbi-optimization is a skill for Claude Code, Codex from PBI-Guy/Power-BI-Optimization-Skill. It costs 135 tokens per session (3,128 once invoked), scanned A, original, MIT.

A guide for improving Power BI reports and their underlying data models. Power BI is Microsoft's tool for building interactive reports from data, and DAX is its formula language.

In plain words
What is it for?
Use it to optimise DAX measures, data relationships, report layouts, data-loading queries, storage modes, and row-level security.
Why use it?
It helps diagnose slow reports, queries, refreshes, incorrect calculations, and design problems across formulas, relationships, and visuals.

Skill for Claude CodeCodex

Written for no agent in particular: nothing here depends on one.

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.

agentmods
npx agentmods add skills/pbi-guy/power-bi-optimization-skill/powerbi-optimization
Any agent
npx skills add PBI-Guy/Power-BI-Optimization-Skill --skill powerbi-optimization
Clone the repo
git clone --depth 1 https://github.com/PBI-Guy/Power-BI-Optimization-Skill

Made for: Claude Code, Codex.

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 powerbi-optimization

README.md
[![agentmods](https://agentmods.dev/badge/skills/pbi-guy/power-bi-optimization-skill/powerbi-optimization.svg)](https://agentmods.dev/skills/pbi-guy/power-bi-optimization-skill/powerbi-optimization)
Your own site
<a href="https://agentmods.dev/skills/pbi-guy/power-bi-optimization-skill/powerbi-optimization"><img src="https://agentmods.dev/badge/skills/pbi-guy/power-bi-optimization-skill/powerbi-optimization.svg" alt="Measured on agentmods" height="20"></a>
Per session 135 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 3,128 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin original No closer match found 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.00135 $0.03128
Opus 5 $0.00068 $0.01564
Sonnet 5 $0.00027 $0.00626
Haiku 4.5 $0.00014 $0.00313

Measured 6d ago against content hash b3261ecebc67, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-06, from the pricing page.

Security

Grade A, and why

powerbi-optimization 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 6d 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.

skills/powerbi-optimization/SKILL.md · 345 lines

How it starts

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

Power BI Optimization Skill

Hub skill: Comprehensive Power BI analysis across DAX, model design, and report performance. Invokes specialist skills for deep-dive optimization.


When to Use This Skill

Use when:

  • Analyzing Power BI performance issues (slow reports, queries, refresh)
  • Optimizing DAX measures, semantic models, or report layouts
  • Need triage across multiple domains (DAX + Model + Report)
  • Reviewing Power BI solutions for best practices
  • Troubleshooting incorrect calculations or unexpected behavior

🎯 Quick Reference: When to Use Which Specialist

When you have... Use specialist... Examples
Slow measure/formula @dax-mastery Iterators, context transitions, calculation groups, time intelligence
Schema/relationship issue @model-design Star schema, many-to-many, storage modes, incremental refresh, unused objects
Slow visual/report @report-performance Too many visuals, UX design, accessibility, custom visuals
Slow refresh/load @powerquery-m Query folding, M optimization, connector issues, transformation performance
RLS issue @security-rls Row-level security, dynamic security, performance with RLS

Quick Start: 3-Step Workflow

1️⃣ Scope & Context

  • Identify what to analyze: DAX measure, model structure, report layout, or end-to-end
  • Gather context: data volume, user count, refresh frequency, current performance metrics
  • Check for specific goals: performance target, business requirements, constraints

2️⃣ Detect & Prioritize

Run quick checks across domains:

  • DAX: Iterators (SUMX, FILTER), context transitions, missing variables, time intelligence patterns
  • Model: Star schema validation, cardinality, bi-directional relationships, storage modes
  • Report: Visual count (>10 flag), expensive custom visuals, cross-highlighting, slicer design

Priority framework:

  • P0 - Incorrect results, severe performance (>30s queries)
  • P1 - Major performance issues (10-30s), important UX problems
  • P2 - Moderate impact (5-10s), minor UX issues
  • P3 - Optimization opportunities, cosmetic improvements

Read the full file on GitHub · 345 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. 6d ago First seen · 345 lines · 135 tokens per session scan A b3261ecebc67

Subscribe to this mod's changes

powerbi-optimization is a skill published in the GitHub repository PBI-Guy/Power-BI-Optimization-Skill (24 stars, last pushed 2mo ago), licensed MIT. It adds 135 tokens to every session and 3,128 once invoked, about $0.0007 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Related

Other skills, from other repositories

dotnet-testing-advanced-tunit-advanced

TUnit 進階應用完整指南。當需要使用 TUnit 進行資料驅動測試、依賴注入或整合測試時使用。涵蓋 MethodDataSource、ClassDataSource、Matrix Tests、Properties 過濾。包含 Retry/Timeout 控制、WebApplicationFactory 整合、Testcontainers 多服務編排。 Make sure to use this skill whenever the user mentions TUnit advanced, MethodDataSource, ClassDataSource, Matrix Tests, TUnit dependency…

kevintsengtw/dotnet-testing-agent-skills · 211 tokens

dotnet-testing-autodata-xunit-integration

AutoFixture 與 xUnit 整合完整指南。當需要使用 AutoData 或 InlineAutoData 簡化 xUnit 參數化測試資料準備時使用。涵蓋自訂 Customization 與測試資料屬性,提升測試可讀性與維護性。 Make sure to use this skill whenever the user mentions AutoData, InlineAutoData, MemberAutoData, AutoFixture xUnit integration, or parameterized test data attributes, even if they don't explicitly…

kevintsengtw/dotnet-testing-agent-skills · 181 tokens

dotnet-testing-autofixture-nsubstitute-integration

AutoFixture 與 NSubstitute 整合指南 - 實現自動模擬 (Auto-Mocking)。當需要自動建立 Mock 物件、簡化複雜相依性注入測試時使用。涵蓋 AutoNSubstituteDataAttribute、Frozen 機制、Greedy 建構策略。包含 IMapper (AutoMapper/Mapster) 等特殊相依性的客製化處理。 Make sure to use this skill whenever the user mentions AutoFixture with NSubstitute, auto-mocking, AutoNSubstituteCustomization…

kevintsengtw/dotnet-testing-agent-skills · 217 tokens

dotnet-testing-bogus-fake-data

使用 Bogus 產生擬真假資料的專門技能。當需要產生真實感的姓名、地址、電話、Email、公司資訊等測試資料時使用。涵蓋 Faker 類別、多語言支援、自訂規則、大量資料產生等。 Make sure to use this skill whenever the user mentions Bogus, Faker, fake data, realistic test data, generating names/addresses/emails, or seed data, even if they don't explicitly ask for fake data guidance. Keywords: bogus…

kevintsengtw/dotnet-testing-agent-skills · 178 tokens

dotnet-testing-advanced-aspire-testing

.NET Aspire Testing 整合測試框架完整指南。當需要測試 .NET Aspire 分散式應用程式、設定 AppHost 測試或從 Testcontainers 遷移至 Aspire 測試時使用。涵蓋 DistributedApplicationTestingBuilder、容器生命週期管理、多服務編排、Respawn 配置與時間可測試性設計。 Make sure to use this skill whenever the user mentions .NET Aspire, AppHost testing, DistributedApplicationTestingBuilder, cloud-native…

kevintsengtw/dotnet-testing-agent-skills · 193 tokens

dotnet-testing-advanced

.NET 進階測試技能總覽與引導中心。當使用者詢問「整合測試」、「API 測試」、「容器化測試」、「微服務測試」、「測試框架遷移」、「Testcontainers」、「Aspire 測試」等進階測試需求時觸發。會根據具體需求推薦適合的子技能組合,涵蓋整合測試、Testcontainers、Aspire 測試、框架升級等 8 個進階技能。 Make sure to use this skill whenever the user mentions integration testing, API testing, Testcontainers, .NET Aspire testing, WebApplicationFactory…

kevintsengtw/dotnet-testing-agent-skills · 254 tokens