powerbi-report-conversion
Skill3 starsChanged 7 months agoMITView on GitHub
Power BI report format conversion, merging, splitting, and semantic model rebinding via pbir.tools - PBIR/PBIP/PBIX conversion, multi-report merging, page splitting, thick/thin PBIP operations, and model rebind. Use when the user mentions: convert report, PBIR, PBIP, PBIX, format conversion, merge reports, split pages, split report, rebind dataset, rebind semantic model, thick PBIP, thin report, report merge, report split, combine reports, swap dataset, change semantic model, report publish, download report, report deployment, CI/CD report.
In this repository58 other files it gives its agents.
- powerbi-audit-tenant-settingsSkill
- powerbi-bpa-rulesSkill
- powerbi-connect-pbidSkill
- powerbi-connectSkill
- powerbi-create-pbi-reportSkill
- powerbi-c-sharp-scriptingSkill
- powerbi-custom-visualsSkill
- powerbi-cyber-securitySkill
- powerbi-data-catalog-lineageSkill
- powerbi-data-governance-traceabilitySkill
- powerbi-data-transformationSkill
- powerbi-dax-masterySkill
- powerbi-dax-performanceSkill
- powerbi-daxSkill
- powerbi-deneb-visualsSkill
- powerbi-doctorSkill
- powerbi-duckdb-lakehouseSkill
- powerbi-fabric-appsSkill
- powerbi-fabric-app-templatesSkill
- powerbi-fabric-capacitySkill
- powerbi-fabric-cliSkill
- powerbi-fabric-pipelinesSkill
- powerbi-fabricSkill
- powerbi-lineage-analysisSkill
- powerbi-measure-glossarySkill
- powerbi-medallion-architectureSkill
- powerbi-modelSkill
- powerbi-modifying-theme-jsonSkill
- powerbi-paginated-reportsSkill
- powerbi-pbi-cliSkill
- powerbi-pbip-formatSkill
- powerbi-pbir-cliSkill
- powerbi-pbir-format-enhancedSkill
- powerbi-performance-scaleSkill
- powerbi-power-querySkill
- powerbi-project-managementSkill
- powerbi-python-visualsSkill
- powerbi-refresh-semantic-modelSkill
- powerbi-report-authoringSkill
- powerbi-report-designSkill
- powerbi-reportSkill
- powerbi-report-structureSkill
- powerbi-report-themingSkill
- powerbi-review-reportSkill
- powerbi-review-semantic-modelSkill
- powerbi-r-visualsSkill
- powerbi-security-rlsSkill
- powerbi-source-integrationSkill
- powerbi-spark-livySkill
- powerbi-standardize-naming-conventionsSkill
- powerbi-star-schema-modelingSkill
- powerbi-svg-visualsSkill
- powerbi-te2-cliSkill
- powerbi-te-cliSkill
- powerbi-te-docsSkill
- powerbi-testing-validationSkill
- powerbi-time-series-dataSkill
- powerbi-tmdlSkill
The file
We split this skill into the rules it gives an agent
1 rule. About 0 are common, 1 is distinctive, and 0 are very specific to this project.
≈0
Common · estimate
Many files like this have a rule of this kind.
≈1
Distinctive · estimate
This author's own choices. Worth a look.
0
Very specific
Tied to their project's names, files or tools. Probably skip.
- Common
- Distinctive
- Very specific
- Distinctive: line 215
Always validate before and after structural operations:
≈ “Common” is an estimate: at least 1 in 5 of the 364,980 skill files we read have a rule of the same kind, not the same words. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.
Files
Report Format Conversion & Structural Operations with pbir.tools
pbir.tools enables bidirectional format conversion between Power BI formats, structural report transformations (merge, split), and semantic model rebinding — all essential for CI/CD pipelines, modular report development, and dataset migrations.
Format Overview
| Format | Description | Best Used For |
| PBIR | Folder-based report (text files) | Version control, agent automation, diff-friendly |
| PBIP | Power BI Project (folder + model) | Full project with embedded semantic model |
| PBIX | Binary desktop file | Sharing, legacy publishing, final delivery |
Rule of thumb: Work in PBIR for development, convert to PBIX or publish PBIP for deployment.
Format Conversion
# PBIX → PBIR (extract from binary — for source control)
pbir report convert revenue.pbix --to pbir --output reports/
# PBIR → PBIX (package for distribution)
pbir report convert reports/revenue.Report --to pbix --output dist/
# PBIP → PBIR (decompose project)
pbir report convert revenue.pbip --to pbir --output reports/
# PBIR → PBIP (compose project)
pbir report convert reports/revenue.Report --to pbip --output dist/
# PBIX → PBIP (convert legacy desktop file to project format)
pbir report convert legacy-report.pbix --to pbip --output projects/# Always validate after conversion
pbir validate reports/revenue.Report --qaSemantic Model Rebinding
Swap a report's connected semantic model while preserving all visual design, filters, bookmarks, and layout. Critical for promoting reports across environments (dev → staging → prod) or migrating to a new dataset.
# Rebind to a different semantic model in the same workspace
pbir report rebind reports/revenue.Report \
--workspace "Production" \
--dataset "Revenue Model Prod"
# Rebind to a semantic model in a different workspace
pbir report rebind reports/revenue.Report \
--workspace-id "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx" \
--dataset-id "yyyyyyyy-yyyy-yyyy-yyyy-yyyyyyyyyyyy"
# Rebind using connection string (for XMLA endpoint)
pbir report rebind reports/revenue.Report \
--connection "powerbi://api.powerbi.com/v1.0/myorg/Production" \
--dataset "Revenue Model"
# Verify rebind result
pbir get reports/revenue.Report "datasetReference"
pbir validate reports/revenue.Report --qa # ensure fields still resolveWhen to rebind:
- Promoting reports from dev dataset → prod dataset
- Renaming a semantic model
- Merging two datasets into one
- Migrating from DirectQuery to Import mode model
Report Merging (Combine Multiple Reports)
Combine pages from multiple reports into a single deliverable — essential for executive packs or consolidated dashboards:
# Merge pages from multiple source reports into one
pbir report merge \
--sources reports/revenue.Report,reports/customers.Report,reports/ops.Report \
--output dist/executive-pack.Report
# Merge with page prefix to avoid name collisions
pbir report merge \
--sources reports/revenue.Report,reports/customers.Report \
--prefix-by-source \
--output dist/combined.Report
# Merge specific pages only
pbir report merge \
--sources reports/revenue.Report \
--pages "Revenue Overview,YTD Summary" \
--output dist/quarterly-pack.ReportReport Splitting (Decompose Reports)
Split a multi-page report into individual single-page reports — useful for per-team or per-region distribution:
# Split each page into a separate report
pbir report split-pages reports/master-report.Report \
--output dist/pages/
# Result:
# dist/pages/Revenue-Overview.Report
# dist/pages/Customer-360.Report
# dist/pages/Operations.Report
# Split specific pages only
pbir report split-pages reports/master-report.Report \
--pages "Revenue Overview,YTD Summary" \
--output dist/finance-reports/Thick ↔ Thin PBIP Operations
Thick PBIP = report + embedded semantic model in one .pbip folder
Thin PBIP = report-only .Report connected to a published dataset
# Convert thin report + published dataset → thick PBIP (offline development)
pbir report merge-to-thick \
--report reports/revenue.Report \
--dataset "Revenue Model" \
--workspace "Production" \
--output dev/revenue-thick.pbip
# Split thick PBIP → thin report + publish model separately (Fabric-first workflow)
pbir report split-from-thick dev/revenue-thick.pbip \
--report-output reports/
--model-output models/
# Clear semantic model diagram layout (before publishing for clean view)
pbir report clear-diagram dev/revenue-thick.pbipDownload and Publish (Fabric Integration)
# Download a report from Fabric workspace (as PBIR for version control)
pbir download \
--workspace "Production" \
--report "Revenue Dashboard" \
--format pbir \
--output reports/
# Download as PBIX (for backup or distribution)
pbir download \
--workspace "Production" \
--report "Revenue Dashboard" \
--format pbix \
--output backups/
# Publish to Fabric workspace (overwrite existing)
pbir publish reports/revenue.Report \
--workspace "Production" \
--overwrite
# Publish with new name
pbir publish reports/revenue.Report \
--workspace "Staging" \
--name "Revenue Dashboard [STAGING]"CI/CD Pipeline Patterns
Dev → Staging → Prod Promotion
# Step 1: In CI — download from dev workspace
pbir download --workspace "Development" --report "Revenue Dashboard" --format pbir --output reports/
# Step 2: Rebind to staging dataset
pbir report rebind reports/Revenue-Dashboard.Report \
--workspace "Staging" --dataset "Revenue Model [Staging]"
# Step 3: Validate
pbir validate reports/Revenue-Dashboard.Report --qa --strict
if [ $? -ne 0 ]; then echo "❌ Validation failed"; exit 1; fi
# Step 4: Publish to staging
pbir publish reports/Revenue-Dashboard.Report \
--workspace "Staging" --overwrite
# Step 5: Rebind to prod dataset and publish
pbir report rebind reports/Revenue-Dashboard.Report \
--workspace "Production" --dataset "Revenue Model"
pbir publish reports/Revenue-Dashboard.Report \
--workspace "Production" --overwrite
echo "✅ Report promoted to Production"Bulk Report Migration (New Dataset)
# Migrate all reports in a workspace to a new semantic model
for report in reports/*.Report; do
pbir backup "$report"
pbir report rebind "$report" \
--workspace "Production" \
--dataset "New Revenue Model"
pbir validate "$report" --qa || { echo "Validation failed: $report"; continue; }
pbir publish "$report" --workspace "Production" --overwrite
echo "✅ Migrated: $report"
doneValidation Before Any Structural Change
Always validate before and after structural operations:
# Quick structure check
pbir validate report.Report
# Full QA (field connectivity, broken references, filter validation)
pbir validate report.Report --qa
# Strict mode (fail on warnings too)
pbir validate report.Report --qa --strict
# Output as JSON (for CI parsing)
pbir validate report.Report --qa --json
# Verify field still resolves after rebind
pbir fields find report.Report --verifyOpening Reports
# Open report in Power BI Desktop (for visual review)
pbir open reports/revenue.Report
# Open to a specific page
pbir open reports/revenue.Report --page "Revenue Overview"CLI Reference
pbir report convert report.pbix --to pbir --output reports/ # Convert format
pbir report rebind report.Report --workspace Prod --dataset DS # Rebind dataset
pbir report merge --sources r1.Report,r2.Report --output out.Report
pbir report split-pages report.Report --output dist/pages/
pbir report merge-to-thick --report r.Report --dataset DS --workspace W
pbir report split-from-thick thick.pbip --report-output reports/
pbir download --workspace Prod --report "Revenue" --format pbir
pbir publish report.Report --workspace Prod --overwrite
pbir validate report.Report --qa --strict
pbir backup report.Report && pbir restore report.Report --latestDoes it work?
Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.
No reviews yet
People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.
- It worked
- Partly
- It didn't
Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.
Your trail
Files you open will collect here, so you can find them again.
Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.
Now do this for your own.
Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.

