Skip to content

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

45 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

🛠️ Power BI PBIP Skills

Automation skills for Power BI projects in PBIP format. Streamline your workflow with batch operations, SVG manipulation, semantic documentation, and more.

License: MIT Power BI PowerShell

🎯 What is PBIP?

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

📦 Available Skills

🎨 skill-svg-recolor-powerbi

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-powerbi

Workflow

flowchart 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"]
Loading

📖 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"

🧠 skill-semantic-architect-powerbi

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-powerbi

Workflow

flowchart LR
    A["🤖 Phase 1\nModel DNA Scan"] --> B["🔬 Phase 2\nDeep Research"]
    B --> C["📋 Phase 3\nContext Store"]
    C --> D["👤 Phase 4\nExpert Audit"]
Loading
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)

📊 dashboard — Interactive HTML Dashboard Generator

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


🚀 Getting Started

Prerequisites

  • 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)

Installation

  1. Clone this repository:

    git clone https://github.com/CSalcedoDataBI/powerbi-pbip-tools.git
    cd powerbi-pbip-tools
  2. 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
  3. 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"

📚 Documentation


🤝 Contributing

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/

📄 License

MIT License - see LICENSE for details.


🔗 Links


🌟 More Skills Coming Soon

This repository will grow with more automation skills for Power BI PBIP projects. Stay tuned!

About

🛠️ Automation tools for Power BI projects in PBIP format. Includes SVG icon recoloring, batch operations, and more.

Topics

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors

Languages