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

pip install pbir-utils

🚀 Quick Start

CLI

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

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

# 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
• ⚙️ CI/CD Integration: Validate reports in pipelines before deployment
• 📄 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.