power-bi-deployment

Featured

Import and export TMDL/TMSL formats, manage model lifecycle with transactions, and version-control Power BI semantic models using pbi-cli. Invoke this skill whenever the user mentions "deploy", "export", "import", "TMDL", "TMSL", "version control", "git", "backup", "migrate", "transaction", "commit changes", "rollback", or wants to save/restore model state.

AI & Automation 423 stars 110 forks Updated today MIT

Install

View on GitHub

Quality Score: 93/100

Stars 20%
87
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

# Power BI Deployment Skill Manage model lifecycle with TMDL export/import, transactions, and version control. ## Prerequisites ```bash pipx install pbi-cli-tool pbi-cli skills install pbi connect ``` ## Connecting to Targets ```bash # Local Power BI Desktop (auto-detects port) pbi connect # Local with explicit port pbi connect -d localhost:54321 # Named connections for switching pbi connect -d localhost:54321 --name dev pbi connections list pbi connections last pbi disconnect ``` ## TMDL Export and Import TMDL (Tabular Model Definition Language) is the text-based format for version-controlling Power BI models. ```bash # Export entire model to TMDL folder pbi database export-tmdl ./model-tmdl/ # Import TMDL folder into connected model pbi database import-tmdl ./model-tmdl/ ``` ## TMSL Export ```bash # Export as TMSL JSON (for SSAS/AAS compatibility) pbi database export-tmsl ``` ## TMDL Diff (Compare Snapshots) Compare two TMDL export folders to see what changed between snapshots. Useful for CI/CD pipelines ("what did this PR change in the model?"). ```bash # Compare two exports pbi database diff-tmdl ./model-before/ ./model-after/ # JSON output for CI/CD scripting pbi --json database diff-tmdl ./baseline/ ./current/ ``` Returns a structured summary: - **tables**: added, removed, and changed tables with per-table entity diffs (measures, columns, partitions, hierarchies added/removed/changed) - **relationships**: added, removed, and changed relationships - *...

Details

Author
MinaSaad1
Repository
MinaSaad1/pbi-cli
Created
4 months ago
Last Updated
today
Language
Python
License
MIT

Similar Skills

Semantically similar based on skill content — not just same category

AI & Automation Featured

power-bi-diagnostics

Troubleshoot Power BI model performance, trace query execution, manage caches, and verify the pbi-cli environment using pbi-cli. Invoke this skill whenever the user says "pbi not working", "setup issues", "connection failed", "slow query", "performance", "profiling", "tracing", "health check", "model audit", "pbi setup", or encounters any pbi-cli error. This is the first skill to check when something goes wrong with pbi-cli.

423 Updated today
MinaSaad1
Data & Documents Featured

power-bi-documentation

Auto-document Power BI semantic models by extracting metadata, generating documentation, and cataloging all model objects using pbi-cli. Invoke this skill whenever the user says "document this model", "what's in this model", "list everything", "data dictionary", "model inventory", "audit contents", "catalog", "describe the model", or wants to understand what objects exist in a semantic model.

423 Updated today
MinaSaad1
AI & Automation Featured

power-bi-modeling

Create and manage Power BI semantic model structure using pbi-cli -- tables, columns, measures, relationships, hierarchies, calculation groups, and date/calendar tables. Invoke this skill whenever the user says "create table", "add measure", "add column", "create relationship", "date table", "calendar table", "star schema", "mark as date table", "add hierarchy", "calculation group", or any model-building task. Also invoke when creating multiple measures at once -- the skill contains critical guidance on multi-line DAX expression handling.

423 Updated today
MinaSaad1