# guust-franssens/tableau-to-powerbi-migration architecture

> Architecture diagram of the GitHub repository guust-franssens/tableau-to-powerbi-migration, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-01). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/guust-franssens/tableau-to-powerbi-migration
- Repository: https://github.com/guust-franssens/tableau-to-powerbi-migration

## Overview

This is an AI-assisted Tableau-to-Power BI/Fabric migration toolkit. For one workbook, the user parses a Tableau file into a migration spec, optionally extracts Hyper data, then hands the spec to Copilot migration agents to produce a PBIP semantic model and report. A separate estate workflow surveys, assesses, harvests, converts, and deploys Tableau content. The scripts also capture Tableau reference evidence and package migration handovers; sampled evidence shows some helper relationships, but not every conversion or deployment call path.

Main entry points: [`scripts/package_unit.py`](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/package_unit.py) (Handover package), [`scripts/capture_tableau_oracle.py`](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/capture_tableau_oracle.py) (Oracle capture), [`scripts/tableau_render_capability.py`](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/tableau_render_capability.py) (Render capability), [`scripts/assess_estate.py`](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/assess_estate.py) (Estate assessment)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_migration["Workbook migration"]
  node_parser["Workbook parser<br/>[parse_tableau.py]"]
  node_hyper["Hyper extraction"]
  node_spec["Migration spec"]
  node_agents["Copilot migration agents<br/>[.github]"]
  node_pbip["Power BI PBIP output"]
end

subgraph group_estate["Estate migration"]
  node_survey["Engine survey"]
  node_assess["Estate assessment<br/>[assess_estate.py]"]
  node_harvest["Estate asset harvest"]
  node_estate_run["Estate conversion run<br/>[run_estate.py]"]
  node_deploy["Estate deployment<br/>[deploy_estate.py]"]
end

subgraph group_evidence["Tableau evidence"]
  node_oracle_capture["Oracle capture"]
  node_oracle_manifest["Oracle manifest"]
  node_render["Render capability"]
  node_view_types["View classification"]
end

subgraph group_handover["Handover and validation"]
  node_handover["Handover package<br/>[package_unit.py]"]
  node_queue["Repair work queue<br/>[read_handover.py]"]
  node_model_check["Model validation"]
end

subgraph group_shared["Shared foundations"]
  node_bundle["Bundle discovery<br/>[bundle_corpus.py]"]
  node_migration_bundle["Migration bundle"]
  node_engine["Engine source resolver<br/>[engine_source.py]"]
  node_tableau_env["Tableau credentials<br/>[tableau_env.py]"]
  node_provenance["Input provenance"]
  node_identity["Object identity<br/>[object_identity.py]"]
  node_filesystem["Package integrity"]
  node_role_identity["Package role identity"]
  node_reference["Reference evidence"]
  node_host_paths["Host path handling<br/>[host_paths.py]"]
end

node_user(("Migration operator"))
node_tableau["Tableau workbooks"]
node_fabric(("Power BI / Fabric"))

node_user -->|"runs parser"| node_parser
node_tableau -->|"provides workbook"| node_parser
node_parser -->|"writes spec"| node_spec
node_user -.->|"optionally runs"| node_hyper
node_hyper -->|"adds extract data"| node_spec
node_user -->|"starts orchestrator"| node_agents
node_spec -->|"guides migration"| node_agents
node_agents -->|"builds project"| node_pbip
node_pbip -->|"opens in Desktop"| node_fabric
node_user -->|"starts site workflow"| node_survey
node_survey -->|"survey then assess"| node_assess
node_assess -->|"assess then harvest"| node_harvest
node_harvest -->|"harvest then convert"| node_estate_run
node_estate_run -->|"convert then deploy"| node_deploy
node_tableau -.->|"supplies reference views"| node_oracle_capture
node_oracle_capture -->|"passes captured records"| node_oracle_manifest
node_oracle_capture -->|"checks render capability"| node_render
node_oracle_capture -->|"classifies views"| node_view_types
node_handover -->|"provides repair input"| node_queue
node_model_check -->|"discovers artifacts"| node_bundle
node_estate_run -->|"runs model gate"| node_model_check
node_estate_run -->|"uses bundle logic"| node_migration_bundle
node_survey -->|"resolves engine"| node_engine
node_assess -->|"loads environment"| node_tableau_env
node_assess -->|"checks render capability"| node_render
node_harvest -->|"resolves engine"| node_engine
node_harvest -->|"parses workbooks"| node_parser
node_oracle_capture -->|"loads environment"| node_tableau_env
node_oracle_capture -->|"uses capability checks"| node_render
node_render -->|"uses environment"| node_tableau_env
node_render -->|"uses view types"| node_view_types
node_migration_bundle -->|"resolves engine"| node_engine
node_handover -->|"uses bundle model"| node_migration_bundle
node_handover -->|"discovers bundle artifacts"| node_bundle
node_handover -->|"checks object identity"| node_identity
node_handover -->|"checks package files"| node_filesystem
node_handover -->|"checks package roles"| node_role_identity
node_role_identity -->|"uses identity rules"| node_identity
node_role_identity -->|"uses verified package"| node_filesystem
node_role_identity -->|"uses reference evidence"| node_reference
node_reference -->|"uses identity index"| node_identity
node_oracle_manifest -->|"uses bundle discovery"| node_bundle
node_provenance -->|"uses revision identity"| node_identity

click node_parser "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/parse_tableau.py"
click node_hyper "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/extract_hyper_data.py"
click node_agents "https://github.com/guust-franssens/tableau-to-powerbi-migration/tree/master/.github"
click node_survey "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/run_engine_survey.py"
click node_assess "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/assess_estate.py"
click node_harvest "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/harvest_estate_assets.py"
click node_estate_run "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/run_estate.py"
click node_deploy "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/deploy_estate.py"
click node_oracle_capture "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/capture_tableau_oracle.py"
click node_oracle_manifest "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/tableau_oracle_manifest.py"
click node_render "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/tableau_render_capability.py"
click node_view_types "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/tableau_view_types.py"
click node_handover "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/package_unit.py"
click node_queue "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/read_handover.py"
click node_model_check "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/check_empty_model.py"
click node_bundle "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/bundle_corpus.py"
click node_migration_bundle "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/migration_bundle.py"
click node_engine "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/engine_source.py"
click node_tableau_env "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/tableau_env.py"
click node_provenance "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/stamp_tableau_provenance.py"
click node_identity "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/object_identity.py"
click node_filesystem "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/package_filesystem.py"
click node_role_identity "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/package_role_identity.py"
click node_reference "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/reference_evidence.py"
click node_host_paths "https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/host_paths.py"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_parser,node_hyper,node_spec,node_agents,node_pbip toneBlue
class node_survey,node_assess,node_harvest,node_estate_run,node_deploy toneAmber
class node_oracle_capture,node_oracle_manifest,node_render,node_view_types toneMint
class node_handover,node_queue,node_model_check toneRose
class node_bundle,node_migration_bundle,node_engine,node_tableau_env,node_provenance,node_identity,node_filesystem,node_role_identity,node_reference,node_host_paths,node_user,node_tableau,node_fabric toneIndigo
```

## Components

### Workbook migration

- [Workbook parser](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/parse_tableau.py): `scripts/parse_tableau.py`
- [Hyper extraction](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/extract_hyper_data.py): `scripts/extract_hyper_data.py`
- **Migration spec**
- [Copilot migration agents](https://github.com/guust-franssens/tableau-to-powerbi-migration/tree/master/.github): `.github`
- **Power BI PBIP output**

### Estate migration

- [Engine survey](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/run_engine_survey.py): `scripts/run_engine_survey.py`
- [Estate assessment](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/assess_estate.py): `scripts/assess_estate.py`
- [Estate asset harvest](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/harvest_estate_assets.py): `scripts/harvest_estate_assets.py`
- [Estate conversion run](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/run_estate.py): `scripts/run_estate.py`
- [Estate deployment](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/deploy_estate.py): `scripts/deploy_estate.py`

### Tableau evidence

- [Oracle capture](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/capture_tableau_oracle.py): `scripts/capture_tableau_oracle.py`
- [Oracle manifest](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/tableau_oracle_manifest.py): `scripts/tableau_oracle_manifest.py`
- [Render capability](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/tableau_render_capability.py): `scripts/tableau_render_capability.py`
- [View classification](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/tableau_view_types.py): `scripts/tableau_view_types.py`

### Handover and validation

- [Handover package](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/package_unit.py): `scripts/package_unit.py`
- [Repair work queue](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/read_handover.py): `scripts/read_handover.py`
- [Model validation](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/check_empty_model.py): `scripts/check_empty_model.py`

### Shared foundations

- [Bundle discovery](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/bundle_corpus.py): `scripts/bundle_corpus.py`
- [Migration bundle](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/migration_bundle.py): `scripts/migration_bundle.py`
- [Engine source resolver](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/engine_source.py): `scripts/engine_source.py`
- [Tableau credentials](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/tableau_env.py): `scripts/tableau_env.py`
- [Input provenance](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/stamp_tableau_provenance.py): `scripts/stamp_tableau_provenance.py`
- [Object identity](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/object_identity.py): `scripts/object_identity.py`
- [Package integrity](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/package_filesystem.py): `scripts/package_filesystem.py`
- [Package role identity](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/package_role_identity.py): `scripts/package_role_identity.py`
- [Reference evidence](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/reference_evidence.py): `scripts/reference_evidence.py`
- [Host path handling](https://github.com/guust-franssens/tableau-to-powerbi-migration/blob/master/scripts/host_paths.py): `scripts/host_paths.py`

### Other components

- **Migration operator**
- **Tableau workbooks**
- **Power BI / Fabric**

## Connections

- Migration operator → Workbook parser: runs parser (evidence: `README.md`)
- Tableau workbooks → Workbook parser: provides workbook (evidence: `README.md`)
- Workbook parser → Migration spec: writes spec (evidence: `README.md`)
- Migration operator → Hyper extraction: optionally runs (evidence: `README.md`)
- Hyper extraction → Migration spec: adds extract data (evidence: `README.md`)
- Migration operator → Copilot migration agents: starts orchestrator (evidence: `README.md`)
- Migration spec → Copilot migration agents: guides migration (evidence: `README.md`)
- Copilot migration agents → Power BI PBIP output: builds project (evidence: `README.md`)
- Power BI PBIP output → Power BI / Fabric: opens in Desktop (evidence: `README.md`)
- Migration operator → Engine survey: starts site workflow (evidence: `README.md`)
- Engine survey → Estate assessment: survey then assess (evidence: `README.md`)
- Estate assessment → Estate asset harvest: assess then harvest (evidence: `README.md`)
- Estate asset harvest → Estate conversion run: harvest then convert (evidence: `README.md`)
- Estate conversion run → Estate deployment: convert then deploy (evidence: `README.md`)
- Tableau workbooks → Oracle capture: supplies reference views
- Oracle capture → Oracle manifest: passes captured records (evidence: `scripts/capture_tableau_oracle.py`)
- Oracle capture → Render capability: checks render capability (evidence: `scripts/capture_tableau_oracle.py`)
- Oracle capture → View classification: classifies views (evidence: `scripts/capture_tableau_oracle.py`)
- Handover package → Repair work queue: provides repair input (evidence: `scripts/read_handover.py`)
- Model validation → Bundle discovery: discovers artifacts (evidence: `scripts/check_empty_model.py`)
- Estate conversion run → Model validation: runs model gate (evidence: `scripts/run_estate.py`)
- Estate conversion run → Migration bundle: uses bundle logic (evidence: `scripts/run_estate.py`)
- Engine survey → Engine source resolver: resolves engine (evidence: `scripts/run_engine_survey.py`)
- Estate assessment → Tableau credentials: loads environment (evidence: `scripts/assess_estate.py`)
- Estate assessment → Render capability: checks render capability (evidence: `scripts/assess_estate.py`)
- Estate asset harvest → Engine source resolver: resolves engine (evidence: `scripts/harvest_estate_assets.py`)
- Estate asset harvest → Workbook parser: parses workbooks (evidence: `scripts/harvest_estate_assets.py`)
- Oracle capture → Tableau credentials: loads environment (evidence: `scripts/capture_tableau_oracle.py`)
- Oracle capture → Render capability: uses capability checks (evidence: `scripts/capture_tableau_oracle.py`)
- Render capability → Tableau credentials: uses environment (evidence: `scripts/tableau_render_capability.py`)
- Render capability → View classification: uses view types (evidence: `scripts/tableau_render_capability.py`)
- Migration bundle → Engine source resolver: resolves engine (evidence: `scripts/migration_bundle.py`)
- Handover package → Migration bundle: uses bundle model (evidence: `scripts/package_unit.py`)
- Handover package → Bundle discovery: discovers bundle artifacts (evidence: `scripts/package_unit.py`)
- Handover package → Object identity: checks object identity (evidence: `scripts/package_unit.py`)
- Handover package → Package integrity: checks package files (evidence: `scripts/package_unit.py`)
- Handover package → Package role identity: checks package roles (evidence: `scripts/package_unit.py`)
- Package role identity → Object identity: uses identity rules (evidence: `scripts/package_role_identity.py`)
- Package role identity → Package integrity: uses verified package (evidence: `scripts/package_role_identity.py`)
- Package role identity → Reference evidence: uses reference evidence (evidence: `scripts/package_role_identity.py`)
- Reference evidence → Object identity: uses identity index (evidence: `scripts/reference_evidence.py`)
- Oracle manifest → Bundle discovery: uses bundle discovery (evidence: `scripts/tableau_oracle_manifest.py`)
- Input provenance → Object identity: uses revision identity (evidence: `scripts/stamp_tableau_provenance.py`)
