Tools built for Power BI engineers

The pbiexpert flywheel connects learning, development, and diagnostic auditing. I build tools that make engineering reliable Power BI systems faster and more repeatable. Each tool shows its real status: live, preview, or in development.

DAX Measure Doctor

Live · free

Finds what makes a DAX measure slow or wrong

Launch DAX Measure Doctor

Paste a measure and see why it is slow or risky.

Paste a DAX measure and it reads it in your browser, line by line, to spot the patterns that make reports slow or numbers wrong: measures called row by row inside an iterator, unsafe division, loops over whole tables. Nothing is uploaded.

What it checks

  • Reads your measure instantly in the browser
  • Finds measures that get recalculated for every row (context transitions)
  • Suggests the rewrite, such as DIVIDE() or REMOVEFILTERS()
  • Gives a maintainability score and says what it can't check

DAX & VertiPaq Calculator

Live · free

Writes time-intelligence DAX and estimates column memory

Launch DAX Calculator

Generate year-on-year and rolling DAX, and see what a column costs in memory.

Build common time-intelligence measures (year-on-year %, rolling totals, fiscal periods) without writing them from scratch, and estimate how much memory a column will take in the model.

What it checks

  • Generates readable DAX with VAR/RETURN and safe division
  • Year-to-date, month-to-date, same period last year and custom rolling windows
  • Estimates a column's memory from its size and number of unique values
  • Tells you when a column is too detailed, such as date-times that should be split

Model Health Snapshot

Live · free

Checks how a semantic model is built

Launch Model Health Snapshot

Check a model's design: relationships, table shape and memory waste.

Load a model file (BIM or TMDL) and it checks the design in your browser: tables that should be a star schema, relationships that filter both ways, many-to-many links that break, and columns that waste memory. No data leaves your computer.

What it checks

  • Runs in your browser; nothing is uploaded
  • Checks star schema, two-way filters and many-to-many relationships
  • Sorts tables into facts, dimensions and bridges for you
  • Exports a summary you can paste into a review or pull request

Direct Lake Fallback Checker

Live · free

Shows when a Fabric model will fall back to slower queries

Launch Direct Lake Simulator

Find what makes a Direct Lake model fall back to DirectQuery.

Direct Lake models in Fabric fall back to slower DirectQuery when certain things are in the model. Pick your setup and it shows which ones apply, how much slower and costlier queries get, and the fix for each.

What it checks

  • Simulates the 8 known causes of Direct Lake fallback
  • Shows the effect on query time and capacity usage
  • Checks row limits for each Fabric size, F2 to F512
  • Gives the PySpark or SQL fix for each cause

Fabric Capacity Calculator

Live · free

Sizes a Fabric or Premium capacity before you buy

Launch Capacity Estimator

Check whether you need a bigger capacity, or a better model.

Model your refresh schedule and memory use against each Fabric F-size and Premium capacity, see where it runs out, and estimate what you avoid paying by fixing the model instead of upgrading.

What it checks

  • Covers every Fabric size from F2 to F512, in your browser
  • Compares peak memory demand with each size's limit
  • Shows short bursts against the 24-hour smoothing Fabric applies
  • A checklist to run before upgrading, with the cost you could avoid

powerbi.dev Diagnostic

In development

Automated model diagnostics (in development)

Use Model Health Snapshot (live)

Profile a semantic model and list what to fix first.

An automated check that ranks columns by memory, finds overly detailed columns, flags two-way relationship chains and measures that need work.

What it checks

  • Ranks columns by how much memory they use
  • Finds unused ID columns and over-detailed timestamps
  • Flags relationships with more than one filter path
  • Scores readiness for Fabric Direct Lake

BIKit Lite Quality Gate

Preview

Checks Power BI changes before they are merged

Open the BIKit playground

Catch DAX and relationship problems in a pull request, before they ship.

Checks Power BI Project (PBIP) and TMDL models against a set of rules whenever someone proposes a change. The in-browser playground is live; the command-line tool and CI integration are not yet published to npm.

What it checks

  • 11 rules covering DAX, modelling, governance and performance
  • A command-line tool with pass/fail exit codes (not yet published to npm)
  • Posts results as a comment on GitHub pull requests
  • A playground to try the rules on your own TMDL in the browser

PBIP & TMDL Readiness Check

Live · free

Checks whether a Power BI project is ready for Git

Launch PBIP Readiness Check

See what it takes to put your Power BI work in Git with reviews.

Answer a few questions or paste your folder structure, and it checks whether your Power BI project is ready for source control and pull-request reviews, then generates the files you need.

What it checks

  • Runs in your browser from a short questionnaire or your folder tree
  • Checks folder layout, Git setup and review automation
  • Generates a .gitignore, GitHub Actions and Azure DevOps pipelines
  • Exports a readiness report and a review checklist

CI/CD Pipeline Template Hub

Preview

Ready-made review pipelines for Power BI projects

Explore Pipeline Templates

Copy a pipeline that checks every Power BI change automatically.

Pipeline templates for Power BI Project (PBIP) and TMDL models: run the BIKit checks, comment on pull requests and sync the Fabric workspace. The templates call the BIKit command-line tool, which is not yet published to npm.

What it checks

  • Templates for GitHub Actions, Azure DevOps, GitLab CI and pre-commit hooks
  • Posts review comments on the exact lines that need attention
  • Set your own score threshold and which rules fail a build
  • Copy or download the YAML in one click

Semantic Model Design Patterns

Live · free

Model designs for common business problems

Explore Design Patterns

Star schemas and DAX for subscriptions, inventory, currencies and dates.

Worked model designs for problems that trip teams up: subscription revenue over time, stock levels at a point in time, converting currencies, and using one date table for several dates.

What it checks

  • Diagrams of each star schema, with active and inactive relationships
  • The DAX measures that go with each design
  • TMDL you can drop into a Git-based Power BI project
  • Designs that avoid two-way filters, so reports stay fast

Visualization Engineering Studio

Live · free

How to choose and build report visuals

Explore Visualization Studio

Decide when a native visual is enough, and what to build when it isn't.

A guide to choosing between native visuals, Deneb, HTML and custom visuals, with working examples: Vega-Lite specifications, HTML KPI cards with sparklines built in DAX, and how each visual ties back to the model.

What it checks

  • A four-step way to decide: native, Deneb, HTML or custom
  • Working Deneb / Vega-Lite examples
  • Accessible HTML KPI cards with small inline sparklines
  • Shows which measures and tables each visual depends on

DAXQuest Interactive Sandbox

Live · free

DAX practice with instant feedback

Start practising DAX

Practise DAX on real problems, right in the browser.

Practise DAX on a sample star-schema model. Write a measure for each challenge and get instant feedback: your answer is checked against accepted patterns and required functions, with hints when you are stuck. 47 challenges across 6 modules.

What it checks

  • An editor with DAX autocomplete and syntax checks
  • A formatter that tidies VAR/RETURN and nested functions
  • A preview of the expected result (sample values, not computed from your DAX)
  • Answer checking, step-by-step hints and the sample model's fields

DAXQuest Team Skills Baseline

Live · free

Shows where your team's DAX skills are strong and weak

Launch Team Skills Baseline

See your team's DAX strengths and gaps, without singling anyone out.

Your team answers a short assessment across foundations, filter context, iterators, time intelligence and optimisation. You get the team's overall picture, the shared blind spots, and practice to close them.

What it checks

  • Results are shown for the team as a whole, never per person
  • An anonymous spread of skill levels across the team
  • Finds shared blind spots, such as measures inside iterators
  • Suggested practice for the team and an exportable report

Diagnostic Skill Assessment

Live · free

A 5-minute DAX and modelling check

Take Diagnostic Assessment

Check your DAX and modelling knowledge in 10 questions.

Ten questions on DAX basics, filter context, iterators, time intelligence and modelling. You get a chart of where you are strong and where to start learning.

What it checks

  • 10 questions on the core ideas
  • An instant breakdown across 5 areas
  • A recommended starting level
  • No sign-up needed

DAX Reference Dictionary

Live · free

Plain guides to key DAX functions

Explore DAX Dictionary

Guides to 12+ DAX functions, with the mistakes to avoid.

Guides to CALCULATE, FILTER, SUMX, AVERAGEX, context transition and time intelligence. Each covers the syntax, common mistakes, and links to practice it.

What it checks

  • 12 guides, including CALCULATE, FILTER, SUMX and AVERAGEX
  • Clear explanations of filter context, row context and context transition
  • The common mistakes and slow patterns to avoid
  • A link to practise each function in the editor

Engineering Maturity Assessment

Live · free

Rates how your team builds and ships Power BI

Launch Maturity Assessment

Rate your Power BI practice on modelling, Git, automation and Fabric.

A 15-question check of how your team works across five areas. It names your biggest bottleneck and gives you a three-step plan to improve.

What it checks

  • 15 questions, answered in your browser
  • Scores for modelling, DAX, source control, automation and governance
  • Places your team on a level from 1 (ad hoc) to 5
  • A 30-, 60- and 90-day plan

Power BI Health Check

Paid service

A full review of your semantic model

See the Health Check

Find what makes your model slow, costly or fragile, and what to fix first.

A fixed-scope review of your semantic model using metadata only, with a written report and a plan to fix it. Covers the model's design, memory use, DAX measures and Power Query refresh.

What it checks

  • Which columns and tables use the most memory, and why
  • Which measures are slow, and why
  • Whether Power Query refresh is doing work it shouldn't
  • A scorecard for leaders and a ranked fix plan

Agentic Power BI Layer (MCP)

In development

Safe AI editing of Power BI models (planned)

Read Agentic Architecture

Let AI coding agents change Power BI models safely, with a human approving.

A planned MCP server and a 7-step safety process for AI coding agents to inspect TMDL models, test DAX and propose checked changes, with a person approving each one. The planning layer exists in the repository; the MCP server is in development.

What it checks

  • A planned MCP server for Claude and Cursor
  • Checks the AI against the real model, so it can't invent measures
  • 7 steps, from inspect to a person approving, before anything is applied
  • A before-and-after diff of every proposed change

The pbiexpert Engineering Flywheel

I use these tools in client Health Checks, and turn what I find into DAXQuest challenges and Engineering Notes. That loop keeps the tools grounded in real Power BI work.