pbi-enterprise-cli 1.2.0

Power BI & Microsoft Fabric automation CLI — TMDL/XMLA/REST backends, Python-native BPA governance, DAX testing & lint, PBIR authoring, MCP server, AI measures

pbi-enterprise-cli

Enterprise-grade Power BI & Microsoft Fabric automation CLI — TMDL/XMLA/REST backends, Python-native BPA governance, DAX testing & lint, PBIR report intelligence, an MCP server for AI agents, and AI-powered measures.

uv tool install pbi-enterprise-cli
pbi doctor                                   # verify setup
pbi --backend file --path . govern check     # governance on your repo's TMDL — any OS
pbi dax lint --fail-on error                 # static DAX analysis
pbi ask "top 10 customers by revenue"        # English → DAX → results

Key differentiators

• Real artifacts on any OS — the file backend reads TMDL/PBIP folders straight from your repo (pure Python, no .NET): governance, BPA, lint, docs, and semantic diff on ubuntu-latest
• Live DAX on any OS — the rest backend runs DAX against published datasets via the executeQueries API; xmla gives full read/write on Windows
• Python-native BPA runner — runs the Best Practice Analyzer BPARules.json format with no .NET; safe AST evaluation with an honest evaluated/skipped tally per run
• Full Fabric lifecycle — item CRUD (Item Definition API), workspaces, git sync, deployment pipelines, OneLake, capacity ops, jobs, Direct Lake diagnostics
• Quality platform — DAX lint/format, report lint + unused-field analysis, dbt-style data tests, schema contracts, RLS matrices, drift detection — all CI-gateable with SARIF output
• AI-agent native — pbi mcp serve exposes everything to Cursor/Copilot/Claude Desktop; 12 bundled Claude Code skills install with pbi connect
• One-step CI — published GitHub Action + pre-commit hooks; scaffold a full project with pbi init

Six backends, one API

Backend	Use for	OS
desktop	Local Power BI Desktop (.pbip)	Windows
xmla	Premium / Fabric read-write	Windows
file	TMDL/PBIP repo artifacts — governance, lint, docs, diff	Any
rest	Live DAX via executeQueries	Any
fabric	Live model writes via the Item Definition API (no Windows)	Any
mock	Unit tests, demos	Any

Command surface

model · measure · dax (query/test/lint/format/coverage) · report (authoring + lint/field-usage/diff/a11y) · visual · layout · theme · filter · govern (rules/BPA/plugins/SARIF/tenant scan) · tenant (usage/access/labels) · security · test (data/schema/rls/seed) · partition · deploy · snapshot · env (incl. drift) · diff · fabric (items/workspaces/git/pipelines/onelake/capacity/jobs/directlake) · pquery (M folding/lint) · ops (refresh chains/health) · migrate (direct-lake/pbix/dbt) · docs (dictionary/ERD/site) · mcp · ask · introspect · init · watch · server · skills

Install options

# Recommended
uv tool install pbi-enterprise-cli
uv tool install "pbi-enterprise-cli[all]"   # everything

# Alternative
pipx install pbi-enterprise-cli

# Fallback
pip install pbi-enterprise-cli

Extra	Adds
[ai]	Claude AI: pbi ask, measure generate, govern explain
[xmla]	MSAL auth for XMLA/Fabric + device flow
[sources]	SQL / Excel / REST source profiling
[server]	FastAPI REST server
[viz]	WCAG theme validation

Requirements

• Python 3.10–3.13
• Windows for the desktop and xmla backends (.NET AMO, DLLs bundled)
• Linux/macOS fully supported via the file, rest, and mock backends

Links

• GitHub Repository
• Full Documentation
• Standard Operating Procedure
• XMLA Auth Guide
• Changelog
• Security Policy
• Issues