# lineage-analysis

lineage-analysis finds every Power BI report tied to a semantic model across Fabric workspaces, without needing admin rights.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, Windsurf (Devin Desktop), Claude.ai · ★ 1104 repo stars
- Author: Kurt Buhler
- License: GPL-3.0 · policy=link-only · description only; the file stays with the author
- Source: https://github.com/data-goblin/power-bi-agentic-development/tree/HEAD/plugins/semantic-models/skills/lineage-analysis/SKILL.md
- Updated: 2026-10-28
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/lineage-analysis

## What it does

The skill runs `scripts/get-downstream-reports.py`, which walks the workspaces a user can reach and checks each report's `datasetId`, using 8 parallel workers. You can target it by workspace and model name or by a dataset GUID directly, with plain or JSON output. It needs the `azure-identity` and `requests` packages, and authenticates through `DefaultAzureCredential`, so `az login`, a managed identity, or env variables all work.

Workspace contributor rights are enough, but then only workspaces you can access show up in results. Covering the whole tenant means passing `--dataset-id` with an admin token against the `admin/reports` endpoint instead.

The scan only catches Power BI reports. Excel workbooks with live connections, composite models, explorations, Fabric notebooks, data agents, paginated `.rdl` reports, dataflows, and third-party XMLA clients fall outside its reach, so a full dependency picture requires Fabric's own lineage endpoints via `fab api` or checking connections directly inside the Power BI service. It also isn't built for scanning dozens of models in a row: each run re-scans every reachable workspace, and looping it risks hitting API throttling.

## Requirements
- Works with: Power BI

## Install

### Claude Code (native platform)

1. **Plugin marketplace**
In the agent chat (not a shell):
```text
/plugin marketplace add data-goblin/power-bi-agentic-development
```
In the agent chat (not a shell):
```text
/plugin install semantic-models@power-bi-agentic-development
```
This installs the whole semantic-models plugin with all its skills

2. **Skills CLI (Vercel)**
```bash
npx skills add data-goblin/power-bi-agentic-development --skill lineage-analysis -a claude-code
```

3. **Manually: put the files in place**
- File: `~/.claude/skills/lineage-analysis/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/lineage-analysis/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add data-goblin/power-bi-agentic-development --skill lineage-analysis -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/lineage-analysis/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add data-goblin/power-bi-agentic-development --skill lineage-analysis -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/lineage-analysis/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install data-goblin/power-bi-agentic-development plugins/semantic-models/skills/lineage-analysis
```

2. **Manually: put the files in place**
- File: `.github/skills/lineage-analysis/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add data-goblin/power-bi-agentic-development --skill lineage-analysis -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/data-goblin/power-bi-agentic-development --path plugins/semantic-models/skills/lineage-analysis
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/lineage-analysis/SKILL.md` — The legacy .windsurf/skills/ path still works

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/data-goblin/power-bi-agentic-development/tree/HEAD/plugins/semantic-models/skills/lineage-analysis/SKILL.md

## When to use it
- check which reports break if a model changes
- spot reports sitting in unexpected workspaces, copies or forks
- map dependencies between a model and its reports before deleting it
- tell PBIR reports apart from legacy ones that need converting

## Example prompts
- Find every report that depends on Model Name in Workspace Name
- Show downstream dependencies for the dataset with GUID <guid>
- Output the model's lineage as JSON for further processing

## Similar
- [azure-mgmt-fabric-py](https://affpapa.org/en/nevibecode/skills/azure-mgmt-fabric-py.md) — skill · ★ 3232 repo stars
- [microsoft-fabric-unified-analytics](https://affpapa.org/en/nevibecode/skills/microsoft-fabric-unified-analytics.md) — skill · 282 installs
- [power-bi-devops-alm-best-practices](https://affpapa.org/en/nevibecode/rules/power-bi-devops-alm-best-practices.md) — rule · ★ 41430 repo stars
- [powerbi-modeling](https://affpapa.org/en/nevibecode/skills/powerbi-modeling.md) — skill · 9934 installs
- [power-bi-build](https://affpapa.org/en/nevibecode/skills/power-bi-build.md) — skill · 688 installs
- [power-bi-salespulse-360-dashboard](https://affpapa.org/en/nevibecode/skills/power-bi-salespulse-360-dashboard.md) — skill · 661 installs

From the same set: [data-goblin/power-bi-agentic-development](https://affpapa.org/en/nevibecode/by/data-goblin/power-bi-agentic-development.md) — 59 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
