A tool for running and checking DAX, the formula and query language used by Power BI, against a connected Power BI Desktop data model.

Use it to run DAX queries, return table data as text formats such as JSON or CSV, validate expressions, and explore tables and summaries.

It lets you test formulas and inspect model data before saving a measure or relying on an unverified query.

powerbi-dax — Skill for Claude Code and Codex by santoshkanthety

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.

Any agent

npx skills add santoshkanthety/powerbi-agent --skill powerbi-dax

Clone the repo

git clone --depth 1 https://github.com/santoshkanthety/powerbi-agent

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.

README.md

[![agentmods](https://agentmods.dev/badge/skills/santoshkanthety/powerbi-agent/powerbi-dax/github.svg)](https://agentmods.dev/skills/santoshkanthety/powerbi-agent/powerbi-dax)

Your own site

<a href="https://agentmods.dev/skills/santoshkanthety/powerbi-agent/powerbi-dax"><img src="https://agentmods.dev/badge/skills/santoshkanthety/powerbi-agent/powerbi-dax/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

Your own site · 80×15

<a href="https://agentmods.dev/skills/santoshkanthety/powerbi-agent/powerbi-dax"><img src="https://agentmods.dev/badge/skills/santoshkanthety/powerbi-agent/powerbi-dax.svg" alt="Reviewed on agentmods" width="80" height="20"></a>

Per session 113 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.

When invoked 693 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 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.

Model	Per session	Once invoked
Fable 5.1	$0.00113	$0.00693
Opus 5	$0.00056	$0.00347
Sonnet 5	$0.00023	$0.00139
Haiku 4.5	$0.00011	$0.00069

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

Security

Grade A, and why

powerbi-dax 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 12d 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-dax/SKILL.md · 62 lines

How it starts

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

Skill: Run and Validate DAX

Trigger

Activate when the user wants to run a DAX query, test a DAX expression, validate syntax, explore model data via DAX, or aggregate values from the connected Power BI Desktop model.

Prerequisites

Must have an active connection — run pbi-agent connect first if DAX commands fail with "no connection".

Commands

# Run a DAX query (default table output)
pbi-agent dax query "EVALUATE TOPN(10, Sales)"

# Pick output format
pbi-agent dax query "EVALUATE VALUES('Product'[Category])" --format json
pbi-agent dax query "EVALUATE Sales" --format csv

# Constrain to a specific table context
pbi-agent dax query "CALCULATE(SUM(Sales[Amount]))" --table Sales

# Pin the SSAS port (skip auto-detect)
pbi-agent dax query "EVALUATE INFO.TABLES()" --port 56123

# Validate an expression without executing
pbi-agent dax validate "CALCULATE(SUM(Sales[Amount]), YEAR(Sales[Date])=2024)"

Shell Quoting Notes

Multi-line DAX (VAR / RETURN) passed as a shell argument loses line breaks and breaks parsing. For multi-line expressions:

Prefer inline single-expression form: DIVIDE([A] - [B], [B]) instead of VAR x = [A] VAR y = [B] RETURN ...
If VAR/RETURN is required, test the single-line collapsed form first (VAR x = ... RETURN ... on one line — DAX accepts whitespace separators)

Common Exploration Patterns

# Inventory the model
pbi-agent dax query "EVALUATE INFO.TABLES()"
pbi-agent dax query "EVALUATE INFO.MEASURES()"
pbi-agent dax query "EVALUATE INFO.RELATIONSHIPS()"

# Preview a table
pbi-agent dax query "EVALUATE TOPN(10, Sales)"

# Row count
pbi-agent dax query "EVALUATE ROW(\"Count\", COUNTROWS(Sales))"

# Group-by aggregation
pbi-agent dax query "EVALUATE SUMMARIZECOLUMNS(Products[Category], \"Total\", SUM(Sales[Amount]))"

Common Failures

"No active connection" → run pbi-agent connect
Syntax error on VAR/RETURN → collapse to single-line DIVIDE / inline form, or test with pbi-agent dax validate first
Table not found → run pbi-agent model tables to verify the exact name (case-sensitive)

Read the full file on GitHub · 62 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.

12d ago First seen · 62 lines · 0 tokens per session scan A d3ee346e2be0

Subscribe to this mod's changes

powerbi-dax is a skill published in the GitHub repository santoshkanthety/powerbi-agent (2 stars, last pushed 13d ago), licensed MIT. It adds 113 tokens to every session and 693 once invoked, about $0.0006 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-31.

Analytics and metrics Claude Code ai-agent analytics-engineering claude-skills data-governance dax

seshat-bi

Route a BI project through Seshat BI's governed seven-stage readiness flow. Use when a user asks to inspect a retail source, initialize a Seshat project, find the truthful next action, validate readiness evidence, or stop at the correct human approval gate.

Kemetra/Seshat-BI · 58 tokens

Data Retention Schedule Review

Use when reviewing a draft or existing data retention schedule to inventory data categories against stated purposes, collect retention-period facts, flag legal-hold interactions, and surface orphaned-data and vendor-coverage gaps for attorney review.

zgbrenner/agentcounsel · 49 tokens

powerbi-workflows

Route guarded Power BI work -- design, native report authoring, semantic-model operations, published queries, QA, bounded formatting, and PBIP adoption -- to the correct Seshat or official Microsoft surface under Seshat BI's gates.

Kemetra/Seshat-BI · 53 tokens

dbt-workflows

Route dbt intent to Seshat's governed shadow workflow or the official dbt Labs competence and execution owner, without bypassing readiness or evidence.

Kemetra/Seshat-BI · 35 tokens

dagster-workflows

Route Dagster intent to Seshat's governed medallion workflow or the official Dagster competence owner without bypassing readiness, approvals, or evidence.

Kemetra/Seshat-BI · 36 tokens

pbi-mcp-doctor

Use when a user asks whether or how to wire Microsoft's official Power BI MCP servers into a Seshat BI workspace: run the read-only environment doctor, map a task to the governed Power BI surface (including the official report-authoring skill), generate a safe read-only config template, or run the mocked read-only…

Kemetra/Seshat-BI · 73 tokens