skills.rest
fabioc-aloha
fabioc-alohaCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

pbi-measure-optimize

Analyze DAX measures for performance bottlenecks and propose semantics-preserving refactors.

Updated Aug 23, 2026
Search Tags:#performance#optimization#dax#measure#pbi#powerbi
One-click install
npx skills add https://github.com/fabioc-aloha/PBI-Visual-Assistant --skill pbi-measure-optimize
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: pbi-measure-optimize
Source: https://github.com/fabioc-aloha/PBI-Visual-Assistant/tree/main/.github/skills/pbi-measure-optimize
Command: npx skills add https://github.com/fabioc-aloha/PBI-Visual-Assistant --skill pbi-measure-optimize

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Identifies performance bottlenecks in DAX measures and suggests safe, semantics-preserving optimizations.

Core Features & Use Cases

  • Pattern detection: Inventory measures, detect common anti-patterns, and propose refactors.
  • Equivalence checks: Verify that rewritten measures return identical results across contexts.
  • Progressive optimization: Present before/after rewrites with business impact and risk notes.
  • Use Case: A model with dozens of measures shows slow refresh; optimize to improve performance without changing results.

Quick Start

Load your Power BI model and run the optimization pipeline on a slow measure to see before/after improvements.

Frequently Asked Questions about pbi-measure-optimize

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

FAQPage Schema
How do I optimize slow DAX measures in Power BI without changing the results?▼

DAX measure optimization analyzes semantic models to detect performance bottlenecks and proposes semantics-preserving refactoring options. It scans measures, patterns, and dependencies, then presents before/after results with business impact estimates and risk notes.

What are common DAX anti-patterns that cause Power BI performance bottlenecks?▼

Common DAX anti-patterns that cause performance bottlenecks include inefficient measure dependencies and complex nested calculations. Pattern detection inventories your measures to identify these issues and proposes safe refactors to speed up slow refresh times.

Can I refactor DAX measures and verify they return identical results across contexts?▼

Equivalence checks verify that rewritten DAX measures return identical results across contexts. This ensures your semantics-preserving refactoring options maintain exact outputs while improving performance bottlenecks in your Power BI model.

What do I need to provide to analyze DAX measures for performance bottlenecks?▼

Analyzing DAX measures for performance bottlenecks requires access to your Power BI model schema and a safe execution context. Load your model to run the optimization pipeline and see before/after improvements on slow measures.

When should I optimize DAX measures in my Power BI semantic model?▼

You should optimize DAX measures when a Power BI model with dozens of measures shows slow refresh times. Progressive optimization presents before/after rewrites with business impact estimates and risk notes to safely improve performance.

Related Skills

Explore More Data & Analytics Skills→
jaimedhenriquesjaimedhenriques

powerbi-modeling

Analyze Power BI semantic models for design, DAX, and relationship issues.

Community
Advanced
basmawebinfo-hubbasmawebinfo-hub

Performance Benchmarker

Measure application and infrastructure performance to identify bottlenecks and validate service level objectives.

Community
Advanced
marcelodfelmanmarcelodfelman

Power BI Modeling

Build and manage Power BI semantic models with pbi-cli.

Community
Advanced
jabrenajabrena
423

163-java-profiling-refactor

Refactor Java code from profiling data to address CPU, memory, and threading bottlenecks.

Community
Advanced