pbir-utils is a Python library designed to streamline the tasks that Power BI developers typically handle manually in Power BI Desktop. This module offers a range of utility functions to efficiently manage and manipulate PBIR (Power BI Enhanced Report Format) metadata.

📚 Documentation

View Full Documentation →

• CLI Reference - Command-line usage and examples
• Python API - Library documentation and code examples
• CI/CD Integration - Pipeline integration and validation

📦 Installation

# Using pip
pip install "pbir-utils[ui]"

# Using uv
uv add "pbir-utils[ui]"

🚀 Quick Start

CLI

# Launch interactive web UI (alias: pbir-utils serve)
pbir-utils ui

# Sanitize a report (dry-run to preview changes)
pbir-utils sanitize "C:\Reports\MyReport.Report" --dry-run

# Validate a report against rules
pbir-utils validate "C:\Reports\MyReport.Report"

# Extract metadata to CSV
pbir-utils extract-metadata "C:\Reports\MyReport.Report"

# Visualize report wireframes
pbir-utils visualize "C:\Reports\MyReport.Report"

Python API

import pbir_utils as pbir

# Sanitize a report
pbir.sanitize_powerbi_report(r"C:\Reports\MyReport.Report", actions=["remove_unused_measures", "standardize_pbir_folders"])

✨ Features

• 💻 CLI Support: Access all utilities directly from the command line
• 🌐 Web UI: Interactive browser-based interface for reports and actions
• ⚙️ CI/CD Integration: Validate reports in pipelines before deployment
• ✅ Validate Reports: Rule-based validation with custom expressions
• 📄 Extract Metadata: Retrieve key metadata from PBIR files
• 🖼️ Wireframe Visualizer: Visualize PBIR report layout
• 🧼 Sanitize Reports: Clean up and optimize reports with YAML configuration
• ⛔ Disable Interactions: Bulk disable interactions
• 🧹 Manage Measures: Remove unused measures, analyze dependencies
• 🔍 Filter Management: Update and sort report-level filters
• 📂 Standardize Folder Names: Organize page and visual folders

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.