Agent skill

Lineage Analysis

by data-goblin in data-goblin/power-bi-agentic-development

Trace relationships between semantic models and downstream reports across Fabric workspaces.

GPL-3.0Auto-check passedData & Analytics

Install Lineage Analysis

skills CLI
$ npx skills add data-goblin/power-bi-agentic-development --skill lineage-analysis -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install data-goblin/power-bi-agentic-development lineage-analysis --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/data-goblin/power-bi-agentic-development.git skills-src && mkdir -p .claude/skills && cp -r skills-src/plugins/semantic-models/skills/lineage-analysis .claude/skills/lineage-analysis && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
lineage-analysis
GitHub stars
1k
Token cost
~1k tokens
SKILL.md length
443 words
Files
2 (incl. scripts)
Skills in repo
33
Repo updated
First seen
Licence
GPL-3.0

At a glance

Trace relationships between semantic models and downstream reports across Fabric workspaces.

  • Asks to find downstream reports
  • SKILL.md covers When to Use, Downstream Reports, Limitations and Interpreting Results, plus 1 more section
  • Runs Python scripts from its folder; calls python3, pip and az
  • Show report lineage

What it does

Lineage Analysis is an agent skill from data-goblin/power-bi-agentic-development. Trace relationships between semantic models and downstream reports across Fabric workspaces. Automatically invoke when the user asks to "find downstream reports", "show report lineage", "impact analysis", "what depends on this dataset", "cross-workspace lineage", "which reports are connected", "get model dependencies", or mentions model-to-report dependency tracing.

Its SKILL.md is about 1k tokens, which your agent loads only when the skill is triggered. The skill folder holds 2 other files, including scripts (for example `scripts/get-downstream-reports.py`).

It sits in Data & Analytics. It works with Power BI. The repository describes itself as: Power BI AI skills and Power BI agents for Claude Code and GitHub Copilot: a plugin marketplace of Power BI skills, subagents, and hooks for semantic models, DAX, TMDL, reports… The licence is GPL-3.0.

When your agent uses it

  • Asks to find downstream reports
  • Show report lineage
  • Impact analysis
  • What depends on this dataset

Example prompts

  • “find downstream reports”
  • “show report lineage”
  • “impact analysis”
  • “/lineage-analysis”

Requirements

  • Python 3

What it can do on your machine

Read from SKILL.md and the folder at commit a301717. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Ships 1 file in scripts/ (Python), which the agent can run.

    Shell commands in SKILL.md call:

    • python3
    • pip
    • az

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md. Its commands use pip and az, which can reach the network depending on how they are called.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Lineage Analysis loads about 1k tokens when it runs. Until then it costs about 96 tokens; SKILL.md has 443 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~96
When it runs · the whole SKILL.md, loaded when a task matches
~1k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); the scripts in this folder are not scanned.

SKILL.md

The full file from data-goblin/power-bi-agentic-development at commit a301717, republished under its GPL-3.0 licence (© data-goblin). 443 words, ~1,023 tokens.

Download SKILL.mdSave it as .claude/skills/lineage-analysis/SKILL.md (or your agent's skills folder). This skill also uses 1 other file; get the full folder from GitHub.
name
lineage-analysis
description
Trace relationships between semantic models and downstream reports across Fabric workspaces. Automatically invoke when the user asks to "find downstream reports", "show report lineage", "impact analysis", "what depends on this dataset", "cross-workspace lineage", "which reports are connected", "get model dependencies", or mentions model-to-report dependency tracing.

Lineage Analysis

Trace downstream dependencies from a semantic model to all connected reports across the tenant. No admin permissions required -- workspace contributor access is sufficient.

When to Use

  • Before modifying or deleting a semantic model, to understand impact
  • Auditing which reports are connected to a model and where they live
  • Identifying orphaned or test reports connected to production models
  • Cross-workspace dependency mapping

Downstream Reports

Run scripts/get-downstream-reports.py to find all reports bound to a semantic model.

bash
# By workspace and model name
python3 scripts/get-downstream-reports.py "Workspace Name" "Model Name"

# By dataset GUID directly
python3 scripts/get-downstream-reports.py --dataset-id <guid>

# JSON output for further processing
python3 scripts/get-downstream-reports.py "Workspace" "Model" --json

Requirements: azure-identity, requests (pip install azure-identity requests). Authenticated via DefaultAzureCredential (works with az login, managed identity, or environment variables).

How it works: Lists all workspaces the user can access, then queries each workspace's reports in parallel (8 workers) checking datasetId. Groups results by workspace. Typically completes in under 10 seconds for ~100 workspaces.

Permissions: Workspace contributor or higher on any workspace to be scanned. Reports in workspaces without access will not appear. For full tenant coverage, use the --dataset-id flag with a tenant admin token and the admin/reports API instead.

Limitations

Reports are not the only consumers. A semantic model can also be consumed by:

  • Analyze in Excel workbooks (.xlsx live connections)
  • Composite models (other semantic models chaining via DirectQuery)
  • Explorations (ad-hoc visual explorations in the Power BI service)
  • Fabric notebooks (connecting via Spark or sempy)
  • Fabric data agents
  • Paginated reports (.rdl)
  • Dataflows referencing the model
  • Third-party tools connecting via XMLA

The script only discovers Power BI reports. For full dependency mapping including these other item types, use the Fabric lineage APIs (fab api "admin/groups/{id}/lineage") or the lineage view in the Power BI service UI.

Not appropriate for many models at once. The script scans all accessible workspaces per invocation. Running it in a loop over dozens of semantic models will generate excessive API calls and risk throttling. For bulk inventory across many models, use the admin scan API (fab api "admin/workspaces/getInfo") when tenant-admin access is available, or the cross-workspace catalog via fab find ... -P type=SemanticModel for a quick non-admin list. Neither alternative resolves report-to-model dependency edges; fab find and the OneLake catalog do not expose lineage. For that you still need either a per-workspace scan (this script's approach) or the official Power BI lineage admin API at fab api "admin/groups/{ws-id}/lineage".

Show full SKILL.md (77 more words)Show less

Interpreting Results

FieldMeaning
Report format PBIRModern format, editable as JSON
Report format PBIRLegacyLegacy format, needs conversion to PBIR for direct editing
Reports in unexpected workspacesMay indicate copies, forks, or thin reports pointing at a shared model
Many downstream reportsHigh-impact model -- changes require coordination
  • semantic-model -- Design, build, refresh, and review models (quality, memory, DAX, design)
  • refreshing-semantic-model -- Trigger and monitor model refreshes
  • fabric-cli (fabric-cli plugin) -- Workspace and item management via fab CLI

© data-goblin, GPL-3.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 1 other file (scripts) in plugins/semantic-models/skills/lineage-analysis of data-goblin/power-bi-agentic-development.

  • SKILL.md
  • scripts/get-downstream-reports.py

Open the folder on GitHubat commit a301717

Compare with similar skills

Lineage Analysis next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Lineage Analysis compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Lineage Analysis this skilldata-goblin/power-bi-agentic-development1k—~1kAutomated safety check: PassGPL-3.0
Power Bi AI ReadinessDKH-DK/Self-Service-Power-BI-Fabric113—~2kAutomated safety check: PassNone
Pbi Report Builderlukasreese/powerbi-claude-skills128—~7.5kAutomated safety check: PassNone
Pbi Docxperiun/skills-xperiun-free116—~3kAutomated safety check: PassMIT
Pbip Dependency Analyzerlukasreese/powerbi-claude-skills128—~3.2kAutomated safety check: PassNone
Pbi Modelo Reviewxperiun/skills-xperiun-free116—~2.9kAutomated safety check: PassMIT

Similar skills

  • Power Bi AI Readiness

    DKH-DK/Self-Service-Power-BI-Fabric

    Score and prepare Power BI semantic models for AI (Fabric Data Agent / Copilot).

    113 GitHub stars~2k tokensUpdated 3 mo ago
    Data & AnalyticsAuto-check passed
  • Pbi Report Builder

    lukasreese/powerbi-claude-skills

    [power-bi] Power BI PBIR Report Builder with IBCS Visuals. An agent skill from lukasreese/powerbi-claude-skills.

    128 GitHub stars~7.5k tokensUpdated 5 mo ago
    Data & AnalyticsAuto-check passed
  • Pbi Doc

    xperiun/skills-xperiun-free

    Documenta projeto Power BI (PBIP) inteiro em markdown estruturado + HTML navegável (mini-site de doc).

    116 GitHub stars~3k tokensUpdated 21 days ago
    Data & AnalyticsAuto-check passed
  • Pbip Dependency Analyzer

    lukasreese/powerbi-claude-skills

    Power BI PBIP Dependency Analyzer. An agent skill from lukasreese/powerbi-claude-skills.

    128 GitHub stars~3.2k tokensUpdated 5 mo ago
    Data & AnalyticsAuto-check passed
  • Pbi Modelo Review

    xperiun/skills-xperiun-free

    Audita modelo Power BI (PBIP) e gera relatório priorizado com anti-patterns, score 0-100 e recomendações acionáveis.

    116 GitHub stars~2.9k tokensUpdated 21 days ago
    Data & AnalyticsAuto-check passed
  • Pbi Dax Create

    xperiun/skills-xperiun-free

    Cria medida DAX a partir de descrição em PT, respeitando o modelo Power BI existente (colunas reais, naming convention, padrões DAX).

    116 GitHub stars~2.6k tokensUpdated 21 days ago
    Data & AnalyticsAuto-check passed

More from data-goblin/power-bi-agentic-development

All 33 skills in this repo
  • Paginated Report

    data-goblin/power-bi-agentic-development

    Author, validate, publish, and test Power BI paginated reports in the RDL format.

    1k GitHub stars~3.5k tokensUpdated yesterday
    Auto-check passed
  • Audit Tenant Settings

    data-goblin/power-bi-agentic-development

    Automatically invoke this skill whenever the user asks about Fabric tenant settings or Power BI tenant settings or auditing tenant settings.

    1k GitHub stars~4.7k tokensUpdated yesterday
    Auto-check passed
  • Bpa Rules

    data-goblin/power-bi-agentic-development

    Interactive BPA rule generation for Power BI semantic models; guided discovery, model investigation, and expert rule authoring.

    1k GitHub stars~4.4k tokensUpdated yesterday
    Auto-check passed
  • Pbip

    data-goblin/power-bi-agentic-development

    Guidance for Power BI Project (PBIP) structure, thick and thin reports, project renames, forks, and validation.

    1k GitHub stars~3.8k tokensUpdated yesterday
    Auto-check passed
  • Review Report

    data-goblin/power-bi-agentic-development

    Actionable feedback on the quality, usage, and effectiveness of Power BI reports.

    1k GitHub stars~4.2k tokensUpdated yesterday
    Auto-check passed
  • Semantic Model

    data-goblin/power-bi-agentic-development

    This skill should be used whenever the user mentions a "semantic model", "data model", or "dataset", or asks to "build", "model", "design", "optimize", "review", or "audit" one, or to "add a…

    1k GitHub stars~2.8k tokensUpdated yesterday
    Auto-check passed

Works with

Questions about Lineage Analysis

What does Lineage Analysis do?

Trace relationships between semantic models and downstream reports across Fabric workspaces. Lineage Analysis is an agent skill from data-goblin/power-bi-agentic-development. Trace relationships between semantic models and downstream reports across Fabric workspaces.

When should I use Lineage Analysis?

Lineage Analysis fits situations like: asks to find downstream reports; show report lineage; impact analysis; what depends on this dataset.

How do I install Lineage Analysis in Claude Code?

Run `npx skills add data-goblin/power-bi-agentic-development --skill lineage-analysis -a claude-code`. Or copy the skill folder (plugins/semantic-models/skills/lineage-analysis in data-goblin/power-bi-agentic-development) into .claude/skills/lineage-analysis in your project. Claude Code loads it when a task matches its description.

How do I install Lineage Analysis in Codex?

Run `npx skills add data-goblin/power-bi-agentic-development --skill lineage-analysis -a codex`. Or copy the skill folder (plugins/semantic-models/skills/lineage-analysis in data-goblin/power-bi-agentic-development) into .agents/skills/lineage-analysis in your project. Codex loads it when a task matches its description.

Can I use Lineage Analysis in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add data-goblin/power-bi-agentic-development --skill lineage-analysis -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/lineage-analysis, .gemini/skills/lineage-analysis, .github/skills/lineage-analysis and .opencode/skills/lineage-analysis in your project.

What does Lineage Analysis need to run?

Going by SKILL.md and its folder, Lineage Analysis needs Python for the scripts in its folder and the command-line tools its instructions call (python3, pip and az). Our summary lists: Python 3.

Does Lineage Analysis access the network?

SKILL.md contains no URLs. Its commands use pip, which can reach the network depending on how they are called. This is read from the text; nothing was executed.

Is Lineage Analysis safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. The check reads SKILL.md only: the scripts in the folder are not scanned, so read them before running anything.

What licence does Lineage Analysis use?

Lineage Analysis is published under the GPL-3.0 licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Lineage Analysis use?

About 1k tokens (SKILL.md is roughly 4.1k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Lineage Analysis?

Skills that share tags, products or a category with Lineage Analysis: Power Bi AI Readiness (DKH-DK/Self-Service-Power-BI-Fabric, 113 stars), Pbi Report Builder (lukasreese/powerbi-claude-skills, 128 stars), Pbi Doc (xperiun/skills-xperiun-free, 116 stars) and Pbip Dependency Analyzer (lukasreese/powerbi-claude-skills, 128 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Lineage Analysis?

data-goblin (a GitHub user) maintains it in data-goblin/power-bi-agentic-development, which has 1,031 GitHub stars. The repository holds 33 skills in this directory. The repository was last updated on October 7, 2026.

Source: data-goblin/power-bi-agentic-development on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.