From pbip
Guides Power BI Project (PBIP) structure including thick/thin reports, project renames, forks, and validation. Use for .pbip, .pbism, .platform, definition.pbir operations.
How this skill is triggered — by the user, by Claude, or both
Slash command
/pbip:pbipThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
PBIP (Power BI Project) is the developer-mode file format for Power BI. It decomposes a `.pbix` binary into human-readable text files organized in folders, enabling source control, external editing, and multi-author collaboration.
PBIP (Power BI Project) is the developer-mode file format for Power BI. It decomposes a .pbix binary into human-readable text files organized in folders, enabling source control, external editing, and multi-author collaboration.
te for the semantic model and
pbir for every report mutation. Never hand-edit PBIR JSON..Report/ + .SemanticModel/ in the same project (definition.pbir uses byPath). A thin report has .Report/ only, connecting to a remote model via byConnection. Thin reports are preferred for managed/shared BI..Report/ and .SemanticModel/ folders can coexist. The .pbip file is optional -- open definition.pbir directly.core.autocrlf or * text=auto in .gitattributes to normalize.pbir desktop refresh for supported report/model changes;
close and reopen Desktop for theme changes.te mv --save, then update each
report with pbir fields replace or replace-table and validate both sides.SourceRef.Entity JSON structure. Easy to miss.<Name>.SemanticModel/DAXQueries/ and <Name>.Report/DAXQueries/. Always check both during renames.Treat PBIX as an opaque Desktop artifact. Do not unzip it, patch its internals, reconstruct PBIR from its contents, or invoke an unapproved extraction engine. Microsoft licensing/EULA questions around third-party engine redistribution are unresolved for this project.
Use Power BI Desktop File > Save As > Power BI Project (.pbip), then work on the resulting
.Report folder with pbir and on the semantic model with te. If Desktop conversion is not
available, stop and ask for a PBIP/PBIR source artifact rather than inventing a conversion path.
| Aspect | PBIX | PBIP |
|---|---|---|
| Format | Single binary file | Folder of text files |
| Source control | Not diff-friendly | Git-ready, human-readable diffs |
| Collaboration | Single author at a time | Multiple authors, merge-friendly |
| External editing | Not supported | VS Code, Tabular Editor, scripts |
| Deployment | File > Publish | Git integration, Fabric APIs, fabric-cicd |
| Data | Contains cached data | cache.abf is gitignored; metadata only in Git |
| Convert | File > Save As > PBIP | File > Save As > PBIX |
The .Report/ folder is required in a PBIP. The .SemanticModel/ folder is optional — a thin report has only .Report/ and points at a remote semantic model via definition.pbir byConnection.
The .pbi/ subfolders in both items (localSettings.json, editorSettings.json, cache.abf, etc.) are all optional — they are per-user/per-machine runtime state generated by Power BI Desktop. A freshly authored PBIP from an external tool may not have any of them, and the project still opens fine in Desktop.
<ProjectName>/
+-- <Name>.pbip # Entry point (references .Report folder) — optional
+-- .gitignore # Recommended; excludes .pbi/localSettings.json and cache.abf
+-- <Name>.SemanticModel/ # OPTIONAL — absent for thin reports
| +-- .pbi/ # All contents OPTIONAL, per-user runtime state
| | +-- localSettings.json # User-specific (gitignored)
| | +-- editorSettings.json # Editor settings (committed)
| | +-- cache.abf # Data cache (gitignored)
| | +-- unappliedChanges.json # Pending Power Query changes
| | +-- daxQueries.json # DAX query view tab settings
| | +-- tmdlscripts.json # TMDL view script tab settings
| +-- definition.pbism # SM entry point (required if .SemanticModel exists)
| +-- definition/ # TMDL format (preferred) — see tmdl skill
| +-- model.bim # TMSL format (legacy alt to definition/, mutually exclusive)
| +-- diagramLayout.json # SM diagram (no external edit)
| +-- DAXQueries/ # .dax files from DAX query view
| +-- TMDLScripts/ # .tmdl files from TMDL view
| +-- Copilot/ # Copilot tooling metadata
| +-- .platform # Fabric identity (displayName, logicalId)
+-- <Name>.Report/ # REQUIRED
| +-- .pbi/ # OPTIONAL runtime state
| | +-- localSettings.json # User-specific (gitignored)
| +-- definition.pbir # Report entry point (required for PBIR format)
| +-- definition/ # PBIR format — see pbir-format skill
| | +-- report.json
| | +-- version.json
| | +-- pages/
| | | +-- pages.json
| | | +-- <page-slug>/ # See "Page folder naming" below
| | | | +-- page.json
| | | | +-- visuals/...
| +-- report.json # PBIR-Legacy format (legacy alt to definition/)
| +-- mobileState.json # Mobile layout (no external edit)
| +-- semanticModelDiagramLayout.json # Diagram positions (table renames)
| +-- CustomVisuals/ # Private custom visual metadata
| +-- StaticResources/
| | +-- SharedResources/ # Base themes, shared resources
| | | +-- BaseThemes/<name>.json # Resolution path: <report>/StaticResources/SharedResources/<item.path>
| | +-- RegisteredResources/ # Custom themes, images, .pbiviz files
| +-- DAXQueries/ # .dax files from report DAX query view
| +-- .platform # Fabric identity
Power BI Desktop uses opaque 20-character hex slugs for new page, visual, bookmark, and filter folders by default (e.g. 847663d71e27e0840063). Per Microsoft docs, these can be renamed to friendly names but the replacement must satisfy:
^[\w-]+$ — word characters (letters, digits, underscore) or hyphen only.name field must match exactly (case-sensitive). The folder may be bare (<slug>/) or suffixed (<slug>.Page/) — both forms are valid on disk. pbir-cli uses the .Page suffix in its CLI path syntax; current Desktop saves omit the suffix.pages.json.pageOrder entries must reference the slug, not the display name. activePageName must be one of the entries in pageOrder.Rename pages with pbir pages rename; it owns the cross-report reference updates. Do not rename a
folder or patch the related JSON by hand.
Items listed in resourcePackages[] are resolved relative to:
<Report>/StaticResources/<package_type>/<item.path>
For a SharedResources package with an item { "path": "BaseThemes/Fluent2-CY26SU03.json" }, Power BI Desktop looks for:
<Report>/StaticResources/SharedResources/BaseThemes/Fluent2-CY26SU03.json
Missing resource files are a common blocking error. If report.json declares themeCollection.baseTheme.type = "SharedResources" and points at a resource that doesn't exist on disk, the report will not open. validate_pbip.py checks this explicitly.
| Task | Read |
|---|---|
| Convert a PBIX source | Working with PBIX Files above -- use Desktop Save As; no extraction |
| Understand entry point file structure | references/pbip-file-types.md -- .pbip, .pbir, .pbism, .platform JSON structure, version properties, byPath vs byConnection |
| Rename a table, measure, or column | te mv --save, then pbir fields replace or replace-table; use the references only to understand validation coverage |
| Fork / duplicate a PBIP project | references/pbip-file-types.md -- update .pbip path, .pbir byPath, .platform logicalId and displayName |
| Work with Copilot tooling files | references/copilot-folder.md -- AI instructions, verified answers, schema, example prompts |
| Edit TMDL model files | tmdl skill -- syntax, authoring, column properties, naming conventions |
| Change a PBIR report | pbir-cli skill -- all report mutations; pbir-format is read-only schema context |
| Verify no broken references after rename | Grep commands below |
.Report/ and .SemanticModel/ subfolders to match the new project name..pbip -- rename the .pbip file and update artifacts[].report.path to point to the renamed .Report folder..pbir -- if the report uses byPath, update the path to point to the renamed .SemanticModel folder..platform files -- set displayName to the new project name in each .platform file. Regenerate logicalId (new GUID) if deploying as a separate Fabric item.Two tools for validation, used together:
scripts/validate_pbip.py — project-level validator for cross-cutting concerns: .pbip root file, .platform identity, semantic model format (TMDL vs TMSL), datasetReference resolution, theme resource resolution on disk, orphan page folders, and the silent-ignore page name regex rule (page names outside ^[\w-]+$ are silently ignored by Power BI Desktop). Delegates deep .Report schema validation to pbir validate if it is on PATH.
python3 scripts/validate_pbip.py <path-to-.pbip-or-project> # validate
python3 scripts/validate_pbip.py <path> --fix # scaffold .gitignore
python3 scripts/validate_pbip.py <path> --json # machine-readable
python3 scripts/validate_pbip.py <path> --no-pbir-cli # skip delegation
Exit codes: 0 clean, 1 warnings only, 2 errors, 3 usage error.
pbir validate <Report.Report> (from the pbir-cli skill) — canonical JSON schema + PBIR structure validator for the .Report folder. Covers JSON syntax, schema compliance, required fields, and optional --qa / --fields / --strict checks.
pbip-validator agent — use for interactive, LLM-driven checking of orphaned references after renames, when you need reasoning over the whole project rather than a deterministic report.
Known gotcha with pbir validate: if the project's .pbi/localSettings.json uses a schema version newer than the one bundled in pbir-cli, pbir validate returns SCHEMA_UNSUPPORTED. Pass --allow-download-schemas to let it fetch the missing schema on demand, or ignore .pbi/ files (they are per-user runtime state and not part of the committed definition).
After any rename or fork operation, verify no old references remain.
# Search for old name across all project files
grep -r "Old Name" "Project.Report/" "Project.SemanticModel/" --include="*.json" --include="*.tmdl" --include="*.dax"
# Search with word boundaries to avoid partial matches
grep -rP "\bOld Name\b" "Project.Report/" "Project.SemanticModel/"
# Look for old name in single-quoted DAX references
grep -r "'Old Name'" --include="*.tmdl" --include="*.dax"
Common missed locations:
Entity refs nested in Conditional.CasesfilterConfig sectionssortDefinition blocks in visual JSONConceptualEntity and ConceptualProperty inside embedded JSONWithin this plugin:
tmdl -- TMDL syntax, authoring, and editing rules for direct .tmdl file editingpbir-format -- PBIR JSON format, visual.json, theme, filters, report extensionsOther plugins:
semantic-models plugin -- tooling and workflows for semantic model development (naming conventions, model quality). Use for working with the actual model content, not just its file format.pbi-desktop plugin -- connecting to Power BI Desktop's local Analysis Services instance via TOM/ADOMD.NETtabular-editor plugin -- Tabular Editor CLI, C# scripting, BPA rules, documentation searchProject structure:
references/pbip-file-types.md -- Entry point file structures (.pbip, .pbir, .pbism, .platform), .pbi/ subfolder, DAXQueries/, TMDLScripts/, model.bim, .gitignore, version properties, JSON examplesreferences/copilot-folder.md -- Copilot/ folder structure (AI instructions, verified answers, schema, example prompts)Rename operations:
references/rename-cascade.md -- Detailed before/after examples for each rename cascade location (TMDL + report files)Fetching Docs: To retrieve current PBIP reference docs, use microsoft_docs_search + microsoft_docs_fetch (MCP) if available, otherwise mslearn search + mslearn fetch (CLI). Search based on the user's request and run multiple searches as needed to ensure sufficient context before proceeding.
External references:
npx claudepluginhub data-goblin/power-bi-agentic-development --plugin pbipManages Power BI reports via the `pbir` CLI: create, explore, format, validate, and publish .pbir/.pbip/.pbix files. Also drives Power BI Desktop (canvas reload, screenshots) and queries semantic models.
Creates and modifies Power BI report files in PBIR/PBIP format using powerbi-report-author and powerbi-desktop CLIs. Use for implementing report specs, adding visuals, and validating PBIR.
Enables programmatic Power BI report and semantic model development using PBIR/PBIP formats, TOM/.NET SDK, TMSL/TMDL, pbi-tools, and ALM Toolkit for CI/CD and code-first workflows.