Skip to main content

TrailsBI: End-to-end Data Lineage, Model Health and AI Readiness for Power BI. One report that maps every source, table, column, measure, visual and page, and tells you what to fix.

Website  ·  Get started  ·  Sample Reports  ·  YouTube

* Power BI is a trademark of Microsoft. TrailsBI is not affiliated with or endorsed by Microsoft.

Trails for Power BI

TrailsBI reads a Power BI project saved as PBIP (TMDL and PBIR files) and builds one self-contained HTML page you can open in any browser. It runs entirely on your machine: no sign-in, no upload, no telemetry.

Everything about your Reports and Semantic Models

Lineage - Follow any field from source to visual

  • Pick a column or measure and see every data source, table and measure it depends on, in navy.
  • Everything built on it, down to the visuals and pages, lights up in teal.
  • Compact cards for the whole picture, detailed cards with usage counts when you need them.
TrailsBI Lineage view on Microsoft's Human Resources sample

Model - Every table, column, measure and relationship

TrailsBI Model view on Microsoft's Retail Analysis sample

Reports - What each page and visual actually uses

TrailsBI Reports view on Microsoft's Regional Sales sample

Health - Best Practice Analyzer, without the setup

TrailsBI Health view on Microsoft's Store Sales sample

AI Readiness - How well Copilot will understand the model

TrailsBI AI Readiness view on Microsoft's Competitive Marketing Analysis sample

Get started

  1. In Power BI Desktop, save your report as a Power BI project: File > Save as > Power BI project (.pbip).

  2. Install TrailsBI (Python 3.9 or later, no other dependencies):

    pip install trailsbi
    

    Or

    uv tool install trailsbi
    
  3. Run it on your project:

    trailsbi "D:\Reports\Sales\Sales.pbip"
    

    This writes TrailsBI Report - Sales - 2026-10-04 16-47.html (with the current date and time) to the current folder. Open it in any browser.

Options:

trailsbi [PROJECT] [-o OUTPUT] [--open] [--embed]

  PROJECT       a .pbip file, the folder that holds it, or a .Report folder
                (default: the current folder, so `trailsbi` alone works inside a project)
  -o, --output  where to write the page: a file name, or a folder for the default name
                (default: "TrailsBI Report - <project> - <date time>.html" here)
  --open        open the page in your browser when it is ready
  --embed       show the report inside Power BI: adds a hidden TrailsBI table to the
                model and a TrailsBI page with the visual to the report (see below).
                Writes the HTML page only with -o or --open

TrailsBI builds one project per run. To cover several reports, run it once for each.

See it inside Power BI

The TrailsBI visual (preview) shows the same five views inside a Power BI report. It reads them from a hidden TrailsBI table that --embed writes into the semantic model.

  1. Close the project in Power BI Desktop, then run: trailsbi "D:\Reports\Sales" --embed
  2. Open the project and refresh (Home > Refresh) so the new table loads.

It also adds a TrailsBI page to the report, hidden in view mode, with the visual on it and its fields already set. The visual is saved inside the report, so there is nothing to import.

The page needs a report saved in the PBIR format (Power BI Desktop's default for projects since 2025). For an older report, --embed writes the table and says so; add the visual yourself: download TrailsBI.pbiviz from the visual's latest release, import it (Visualizations pane: ... > Import a visual from a file) and add it to a page. In the Data pane, right-click and turn on View hidden, then drag TrailsBI > Part and TrailsBI > Chunk onto the visual.

Run --embed again whenever the model or report changes, then refresh. It replaces the table (even if you renamed it) and never adds a second one. It keeps the TrailsBI page as you left it and brings the visual in the report up to date. TrailsBI leaves its own table, page and visual out of the analysis.

The table holds the model's names, DAX and data source addresses, so anyone who can open the report can read them in the visual. Embed it only where that is allowed.

Single file

Each release also has trailsbi.pyz, the whole tool in one file: python trailsbi.pyz "D:\Reports\Sales".

Common Installation Issues

1. Windows: "'trailsbi' is not recognized"

When Python comes from the Microsoft Store or the Python install manager, pip puts the trailsbi command in a Scripts folder that is not on your PATH. pip warns about it during the install, and running trailsbi "pbip-project-path" returns 'trailsbi' is not recognized.

Fix:

  • Add that Scripts folder to your own PATH once. Setup

Privacy and security

  • Reads metadata files only. Never opens cache.abf or any imported data.
  • Makes no network calls and sends no telemetry.
  • Read-only: never writes to your project files, except the TrailsBI table when you ask for it with --embed.
  • The page is one HTML file with no external scripts, fonts or images.

See SECURITY.md for details.

Develop

git clone https://github.com/trailsbi/trailsbi
cd trailsbi
python -m pip install -e . pytest "ruff==0.16.10"
python -m pytest
ruff check . && ruff format --check .

CONTRIBUTING.md explains how the code is laid out.

Licence

Apache License 2.0. See LICENSE and NOTICE.

Trademarks

Power BI is a trademark of Microsoft. TrailsBI is not affiliated with or endorsed by Microsoft.

Metadata

Release files for trailsbi 1.2.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for trailsbi 1.2.0
File Size Uploaded Provenance
trailsbi-1.2.0.tar.gz 237.2 kB With provenance Details

Built distribution (wheel)

Table of built distributions (wheels) for trailsbi 1.2.0
File Interpreter ABI Platform
trailsbi-1.2.0-py3-none-any.whl Python 3 none any Details

Total release size: 450.9 kB

Release files / trailsbi-1.2.0.tar.gz

Download URL trailsbi-1.2.0.tar.gz
Size 237.2 kB
Tags Source
SHA-256 checksum
How to use checksums
f7d89159735d3560ca6536273e358f07790a1d185a566b6eb45f9c04a55fa390
BLAKE2b-256 checksum
How to use checksums
beb318d21da67c0a81a3c92efdbe27da551bad31789180ffbba28982f0c456b7
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.16

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Oct 23, 2026.

Transparency log

Release files / trailsbi-1.2.0-py3-none-any.whl

Download URL trailsbi-1.2.0-py3-none-any.whl
Size 213.6 kB
Tags Python 3
SHA-256 checksum
How to use checksums
08d3fab8365c2e6aeda6af7357ef1c34820dda7743b6d3e0a931fe25641e6243
BLAKE2b-256 checksum
How to use checksums
2d571d792c4bd951bf7bd517530f42de81ccf2b8ca11cd9be37085a04f458a75
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.16

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Oct 23, 2026.

Transparency log

Security for trailsbi 1.2.0

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

Full provenance

All 2 files in this release have been uploaded with provenance metadata.

Select from 2 files

Attestation for trailsbi-1.2.0.tar.gz

PyPI Publish Attestation

PyPI verified that this artifact, at this checksum, originated from the publisher listed below.

Signed by GitHub Actions, verified by PyPI on Oct 23, 2026.

Transparency log

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page