# suryasai87/pbi-metrics-migration-tool architecture

> Architecture diagram of the GitHub repository suryasai87/pbi-metrics-migration-tool, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-17). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/suryasai87/pbi-metrics-migration-tool
- Repository: https://github.com/suryasai87/pbi-metrics-migration-tool

## Overview

This is a Power BI-to-Databricks migration application: users extract or upload a semantic model, configure overrides, translate and validate its measures, generate Metric View definitions, evaluate the migration, and optionally deploy views and create Lakeview dashboards. The graph separates API orchestration, model acquisition, migration logic, and Databricks integrations. Relationships are limited to those supported by the README, excerpts, or SOURCE INDEX; some implementation details and wiring were not sampled.

Main entry points: [`backend/pipeline.py`](https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/pipeline.py) (Migration Orchestrator), [`main.py`](https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/main.py) (FastAPI Service), [`backend/lakeview_client.py`](https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/lakeview_client.py) (Lakeview Client), [`backend/dbx_client.py`](https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/dbx_client.py) (Databricks API Client)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_ui["User Interface"]
  node_ui_app["Migration Wizard<br/>[App.jsx]"]
end

subgraph group_acquisition["Model Acquisition"]
  node_pbi["Power BI Client<br/>[pbi_client.py]"]
  node_tmdl["TMDL Parser<br/>[tmdl_parser.py]"]
  node_report["Report Layout Parser<br/>[report_parser.py]"]
end

subgraph group_migration["Migration Pipeline"]
  node_overrides["Override Rules<br/>[overrides.py]"]
  node_pipeline["Migration Orchestrator<br/>[pipeline.py]"]
  node_translator["DAX Translator<br/>[dax_translator.py]"]
  node_generator["Metric View Generator<br/>[yaml_generator.py]"]
  node_validator["Metric View Validator<br/>[validator.py]"]
  node_evaluator["Evaluation Reporter<br/>[evaluator.py]"]
  node_dashboard_gen["Dashboard Generator"]
end

subgraph group_databricks["Databricks Integration"]
  node_dbx_client["Databricks API Client<br/>[dbx_client.py]"]
  node_lakeview_client["Lakeview Client<br/>[lakeview_client.py]"]
end

node_engineer(("Analytics Engineer"))
node_api["FastAPI Service<br/>[main.py]"]
node_powerbi{{"Power BI"}}
node_workspace{{"Databricks Workspace"}}

node_engineer -->|"uses"| node_ui_app
node_ui_app -->|"calls API"| node_api
node_api -->|"extracts model"| node_pbi
node_api -->|"parses upload"| node_tmdl
node_pbi -->|"reads models"| node_powerbi
node_api -->|"starts migration"| node_pipeline
node_pipeline -->|"filters model"| node_overrides
node_pipeline -->|"translates DAX"| node_translator
node_pipeline -->|"generates DDL"| node_generator
node_pipeline -->|"validates output"| node_validator
node_pipeline -->|"scores results"| node_evaluator
node_pipeline -.->|"optionally generates"| node_dashboard_gen
node_api -->|"deploys views"| node_dbx_client
node_dbx_client -->|"executes statements"| node_workspace
node_pipeline -.->|"optionally deploys"| node_lakeview_client
node_lakeview_client -->|"delegates requests"| node_dbx_client
node_lakeview_client -->|"manages dashboards"| node_workspace

click node_ui_app "https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/frontend/src/App.jsx"
click node_api "https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/main.py"
click node_pbi "https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/pbi_client.py"
click node_tmdl "https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/tmdl_parser.py"
click node_report "https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/report_parser.py"
click node_overrides "https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/overrides.py"
click node_pipeline "https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/pipeline.py"
click node_translator "https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/dax_translator.py"
click node_generator "https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/yaml_generator.py"
click node_validator "https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/validator.py"
click node_evaluator "https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/evaluator.py"
click node_dashboard_gen "https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/dashboard_generator.py"
click node_dbx_client "https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/dbx_client.py"
click node_lakeview_client "https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/lakeview_client.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_ui_app toneBlue
class node_pbi,node_tmdl,node_report toneAmber
class node_overrides,node_pipeline,node_translator,node_generator,node_validator,node_evaluator,node_dashboard_gen,node_api toneMint
class node_dbx_client,node_lakeview_client toneRose
class node_engineer,node_powerbi,node_workspace toneIndigo
```

## Components

### User Interface

- [Migration Wizard](https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/frontend/src/App.jsx): `frontend/src/App.jsx`

### Model Acquisition

- [Power BI Client](https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/pbi_client.py): `backend/pbi_client.py`
- [TMDL Parser](https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/tmdl_parser.py): `backend/tmdl_parser.py`
- [Report Layout Parser](https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/report_parser.py): `backend/report_parser.py`

### Migration Pipeline

- [Override Rules](https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/overrides.py): `backend/overrides.py`
- [Migration Orchestrator](https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/pipeline.py): `backend/pipeline.py`
- [DAX Translator](https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/dax_translator.py): `backend/dax_translator.py`
- [Metric View Generator](https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/yaml_generator.py): `backend/yaml_generator.py`
- [Metric View Validator](https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/validator.py): `backend/validator.py`
- [Evaluation Reporter](https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/evaluator.py): `backend/evaluator.py`
- [Dashboard Generator](https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/dashboard_generator.py): `backend/dashboard_generator.py`

### Databricks Integration

- [Databricks API Client](https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/dbx_client.py): `backend/dbx_client.py`
- [Lakeview Client](https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/backend/lakeview_client.py): `backend/lakeview_client.py`

### Other components

- **Analytics Engineer**
- [FastAPI Service](https://github.com/suryasai87/pbi-metrics-migration-tool/blob/main/main.py): `main.py`
- **Power BI**
- **Databricks Workspace**

## Connections

- Analytics Engineer → Migration Wizard: uses (evidence: `README.md`)
- Migration Wizard → FastAPI Service: calls API (evidence: `README.md`)
- FastAPI Service → Power BI Client: extracts model (evidence: `main.py`)
- FastAPI Service → TMDL Parser: parses upload (evidence: `main.py`)
- Power BI Client → Power BI: reads models (evidence: `backend/pbi_client.py`)
- FastAPI Service → Migration Orchestrator: starts migration (evidence: `main.py`)
- Migration Orchestrator → Override Rules: filters model (evidence: `backend/pipeline.py`)
- Migration Orchestrator → DAX Translator: translates DAX (evidence: `backend/pipeline.py`)
- Migration Orchestrator → Metric View Generator: generates DDL (evidence: `backend/pipeline.py`)
- Migration Orchestrator → Metric View Validator: validates output (evidence: `backend/pipeline.py`)
- Migration Orchestrator → Evaluation Reporter: scores results (evidence: `backend/pipeline.py`)
- Migration Orchestrator → Dashboard Generator: optionally generates (evidence: `README.md`)
- FastAPI Service → Databricks API Client: deploys views (evidence: `main.py`)
- Databricks API Client → Databricks Workspace: executes statements (evidence: `backend/dbx_client.py`)
- Migration Orchestrator → Lakeview Client: optionally deploys (evidence: `README.md`)
- Lakeview Client → Databricks API Client: delegates requests (evidence: `backend/lakeview_client.py`)
- Lakeview Client → Databricks Workspace: manages dashboards (evidence: `backend/lakeview_client.py`)
