# Pbi Report Layer Pbir

> Edit the Power BI report layer as code — pages, visuals, bookmarks, and themes — by writing PBIR JSON files in a PBIP project (offline, Desktop closed).

- **Type:** Skill
- **Install:** `agentstack add skill-luccapinto-agentic-data-kit-pbi-report-layer-pbir`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [luccapinto](https://agentstack.voostack.com/s/luccapinto)
- **Installs:** 0
- **Category:** [Developer Tools](https://agentstack.voostack.com/c/developer-tools)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [luccapinto](https://github.com/luccapinto)
- **Source:** https://github.com/luccapinto/agentic-data-kit/tree/main/.opencode/skills/pbi-report-layer-pbir

## Install

```sh
agentstack add skill-luccapinto-agentic-data-kit-pbi-report-layer-pbir
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# Skill: pbi-report-layer-pbir

The report layer (`.Report/`) is **PBIR** — report metadata decomposed into per-page and
per-visual JSON files, each with a public JSON schema. PBIR is becoming the default report
format (rolling out across Service and Desktop through 2026), and it is explicitly designed to
be edited by tools other than Power BI.

## Hard precondition
**Power BI Desktop must be CLOSED** while editing these `.json` files — live edits corrupt or
get overwritten by autosave.

## `.Report` structure (PBIR)
```
.Report/
  definition.pbir                        ← pointer (model binding)
  definition/
    report.json                          ← master metadata incl. themeCollection
    pages/
      /
        page.json                        ← canvas size, background, displayName
        visuals//visual.json   ← one visual per file
  StaticResources/
    RegisteredResources//.json   ← custom themes (create new themes here)
    SharedResources/BaseThemes/          ← Microsoft base themes — NEVER edit
```

## Navigating
- **Pages:** scan `definition/pages/`; read each `page.json` `displayName` (the user-facing name).
- **Visuals:** files sit under GUID folders. To find "the bar chart", grep `visual.json` for
  `"visualType": "barChart"`.

## Visual anatomy (`visual.json`)
```json
{
  "name": "",
  "position": { "x": 10, "y": 20, "width": 400, "height": 300, "tabOrder": 1 },
  "visual": {
    "visualType": "barChart",
    "query": { "queryState": { "Category": { "projections": [] }, "Y": { "projections": [] } } }
  }
}
```
Positioning is a pixel grid (x=0, y=0 top-left). Generate fresh GUIDs for any new component
(`[System.Guid]::NewGuid()` on Windows, or any UUID generator).

## Themes
1. Create the theme JSON under `StaticResources/RegisteredResources//.json`.
2. Register that `` in `report.json`'s `themeCollection`.
3. Define ≥ 8 `dataColors`. To standardize fonts globally, use the wildcard `visualStyles`:
   ```json
   "visualStyles": { "*": { "*": { "fontSize": [{ "value": 11 }], "fontFamily": [{ "value": "Segoe UI" }] } } }
   ```

## Cautions
- The visual schema evolves with Desktop releases; old keys may be ignored on newer versions.
- Validate JSON against the PBIR schema where possible. Always have the user commit (`git add`)
  before large UI refactors and test by opening the file in Desktop.

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [luccapinto](https://github.com/luccapinto)
- **Source:** [luccapinto/agentic-data-kit](https://github.com/luccapinto/agentic-data-kit)
- **License:** MIT

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-luccapinto-agentic-data-kit-pbi-report-layer-pbir
- Seller: https://agentstack.voostack.com/s/luccapinto
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.