Automation skills for Power BI projects in PBIP format. Streamline your workflow with batch operations, SVG manipulation, semantic documentation, and more.
PBIP (Power BI Project) is an open format that stores Power BI reports and semantic models as plain text files. This enables:
- ✅ Version control with Git
- ✅ Collaboration via pull requests
- ✅ Offline metadata editing
- ✅ Automated batch operations
Automatically change the color of all SVG icons in your Power BI PBIP project.
Use Case: You have a report with 142 icons in blue, and you want to change them all to red in 2 seconds without opening Power BI Desktop.
Clone only this skill:
git clone --filter=blob:none --sparse https://github.com/CSalcedoDataBI/powerbi-pbip-tools.git
cd powerbi-pbip-tools
git sparse-checkout set skills/skill-svg-recolor-powerbiflowchart LR
A["📂 PBIP Project"] --> B["🔍 detect-colors.ps1"]
B --> C["📊 Color Report"]
C --> D["🎨 recolor.ps1"]
D --> E["✅ SVGs Updated"]
E --> F["📊 Open in Power BI"]
📖 Read the full documentation →
Quick Start:
# Detect all colors in your project
.\skills\skill-svg-recolor-powerbi\scripts\detect-colors.ps1 -PbipDir "C:\MyProject"
# Change all blue icons to red
.\skills\skill-svg-recolor-powerbi\scripts\recolor.ps1 -PbipDir "C:\MyProject" -From "#0078D4" -To "#DC143C"Transform technical Power BI data models into fully documented semantic models — auto-generates descriptions, KPIs, and a complete Context Store using MCP (Model Context Protocol) as a bidirectional bridge.
Use Case: You have a model with 12 tables and 87 undocumented columns. The skill scans the model, researches industry KPIs, generates business descriptions for every object, and writes them back — turning you from a manual builder into an Intelligence Auditor.
Clone only this skill:
git clone --filter=blob:none --sparse https://github.com/CSalcedoDataBI/powerbi-pbip-tools.git
cd powerbi-pbip-tools
git sparse-checkout set skills/skill-semantic-architect-powerbiflowchart LR
A["🤖 Phase 1\nModel DNA Scan"] --> B["🔬 Phase 2\nDeep Research"]
B --> C["📋 Phase 3\nContext Store"]
C --> D["👤 Phase 4\nExpert Audit"]
| Phase | Action | Mode |
|---|---|---|
| 1. Scan | Extract tables, columns, relationships via MCP. Classify industry & architecture | 🤖 Auto |
| 2. Research | Web search for industry KPIs, business questions, DAX patterns | 🤖 Auto |
| 3. Context Store | Generate semantic map with descriptions, visibility rules & KPI catalog | 🤖 Auto |
| 4. Audit | Expert reviews & approves → AI writes to the model via MCP | 👤 + 🤖 |
📖 Documentación en Español → · 📖 English Documentation →
Includes:
- 📄 Context Store template with 4 structured sections
- 🔍 Industry research prompts for 7+ industries
- 📏 Naming conventions for DAX measures, descriptions & technical column detection
- 📊 Complete Retail example (Contoso model)
- 🌐 All documentation available in Spanish and English (
.en.md)
A Claude Code plugin (/dashboard) that connects to a Power BI model via MCP
and generates a standalone, interactive HTML dashboard — KPI cards, sparklines and
trend/breakdown charts — from a single command. No HTML required.
Use Case: You have a Power BI model open and want a shareable, offline HTML dashboard
in minutes. Run /dashboard, and Claude queries the model and fills a design-consistent
template with the real values.
Three parts: commands/dashboard.md (the command) · skills/dashboard-builder.md
(the query plan + design rules) · tools/dashboard/template.html (the visual scaffold).
Clone only this plugin:
git clone --filter=blob:none --sparse https://github.com/CSalcedoDataBI/powerbi-pbip-tools.git
cd powerbi-pbip-tools
git sparse-checkout set commands skills/dashboard-builder.md tools/dashboard📖 Read the full documentation → · ▶ Live demo
- Power BI Desktop (with PBIP format support)
- PowerShell 5.1+ (included in Windows)
- Git (optional, for version control)
- MCP Server (required for skill-semantic-architect-powerbi)
-
Clone this repository:
git clone https://github.com/CSalcedoDataBI/powerbi-pbip-tools.git cd powerbi-pbip-tools
-
Or clone only the skill you need:
git clone --filter=blob:none --sparse https://github.com/CSalcedoDataBI/powerbi-pbip-tools.git cd powerbi-pbip-tools git sparse-checkout set skills/skill-svg-recolor-powerbi
-
Try the Demo project:
start examples/Demo/Demo.pbip .\skills\skill-svg-recolor-powerbi\scripts\detect-colors.ps1 -PbipDir ".\examples\Demo" .\skills\skill-svg-recolor-powerbi\scripts\recolor.ps1 -PbipDir ".\examples\Demo" -From "#0078D4" -To "#DC143C"
- SVG Recolor Guide - Complete tutorial with examples
- SVG Recolor README - Skill-specific documentation
- Semantic Architect ES - Documentación en español
- Semantic Architect EN - Full English specification
This repository is designed to be extensible. If you create a new skill for Power BI PBIP automation, feel free to contribute!
Naming convention: skill-{name}-powerbi
Structure for new skills:
powerbi-pbip-tools/
├── skills/
│ ├── skill-svg-recolor-powerbi/ # SVG batch recoloring
│ ├── skill-semantic-architect-powerbi/ # Semantic model documentation
│ └── skill-your-name-powerbi/ # Your new skill
│ ├── README.md
│ ├── SKILL.md # Standard skill format (ES)
│ ├── SKILL.en.md # English version
│ └── scripts/
│ └── your-script.ps1
├── docs/
│ └── skill-your-name-powerbi-guide.md
└── examples/
└── YourExample/
MIT License - see LICENSE for details.
- Author: Cristobal Salcedo
- Repository: github.com/CSalcedoDataBI/powerbi-pbip-tools
- Issues: Report a bug or request a feature
- Iconos Dinámicos en Power BI: PBIP + Antigravity + PowerShell — walkthrough of automating icon changes across a PBIP project (in Spanish)
This repository will grow with more automation skills for Power BI PBIP projects. Stay tuned!