BIEscape
Tableau to Power BI

Open Tableau workbooks in the browser.

BIEscape reads a .twb or .twbx and builds a Tableau to Power BI project (.pbip) you open in Desktop, plus SQL and DAX from calculated fields. It is not a .pbix and not a pixel copy of the dashboard. Hyper extracts use the free desktop converter.

Workbook
Accepts Tableau Desktop workbooks. The sample is the Tableau Superstore 10.0 .twb.
Need Hyper → Excel? Download the Windows desktop app (.exe)

Windows will warn that this installer is unrecognized. Choose More info, then Run anyway.

The Problem

Tableau workbooks are XML (or a zip of XML plus extracts). Calculated fields hide inside proprietary syntax — IIF, ZN, IFNULL, LODs — that warehouses do not run. Rebuilding those formulas by hand is slow, and packaged tables plus hidden columns stay buried unless you unzip the file yourself.

Offloading the workbook to a generic LLM is a privacy non-starter for most corporate audits. You need a deterministic parser you can run locally, plus a hosted try-it path that does not keep the file.

How BIEscape Solves It

In-memory workbook parse
Reads .twb / .twbx in process memory with stdlib xml.etree + zipfile. Hosted uploads are not written to disk and are not sent to an LLM.
Formula transpilation
IIF / ZN / IFNULL / CONTAINS / STARTSWITH (plus IF/CASE, LEN, TRIM, UPPER/LOWER, ABS, ROUND) become CASE / COALESCE / LIKE and ANSI SQL. FIXED, INCLUDE, and EXCLUDE LOD expressions become window functions or grain subqueries.
dbt-ready SQL views
Emits one CREATE VIEW per datasource (row-level calcs as columns; aggregates as comments) for dbt model files. schema.yml is not auto-written; this is not a full dbt package scaffold.
Extract Data
Packaged CSV / TSV / XLS / XLSX become a downloadable .xlsx. Custom SQL is copied to extra sheets, not executed. For Hyper, download the free BIEscape desktop converter.
Inspect Schema
Datasources, all columns (including hidden), parameters, redacted connections, and printable dashboard wireframes.
Power BI project
Convert to Power BI downloads a .pbip you open in Desktop, with visuals, a conversion status, and live database connections that stay live. Tableau to Power BI.
Air-gapped local run
CLI and Streamlit stay on-device. This hosted app is in-memory and non-persistent — it is not air-gapped.

Free Utilities

📊 Excel extract
Packaged tabular files become an .xlsx. TWBX to Excel. For Hyper, download the desktop converter.
🔍 Workbook inspector
Schema, parameters, hidden fields, and dashboard wireframes you can Print to PDF — passwords redacted.
💻 Local CLI
Clone the repo. There is no PyPI package named scapetableau.
git clone https://github.com/lukashalim/scapeTableau.git
pip install -r requirements.txt
python cli.py process sales_report.twbx --output-dir ./models

Architecture & Security

Python is the source of truth. The Next.js routes stream the upload to the engine and return JSON, an Excel file, or a Power BI project zip. Nothing is stored after the response.

                       [ .twb / .twbx bytes ]
                                 │
                                 ▼
                     ┌──────────────────────┐
                     │    engine/parser.py  │ (xml.etree + zipfile)
                     └───────────┬──────────┘
                                 │
                                 ▼
                     ┌──────────────────────┐
                     │    engine/schema.py  │ (Pydantic v2 Models)
                     └───────────┬──────────┘
                                 │
                                 ▼
          ┌──────────────────────┼──────────────────────┐
          ▼                      ▼                      ▼
 engine/transpiler.py     engine/extract.py      engine/pbip/
          │                      │                      │
          └──────────┬───────────┴──────────┬───────────┘
                     ▼                      ▼
              TranspileResult         xlsx or .pbip.zip
          (calculated_fields, sql_script,
           inspect, extract_inventory, dashboards)
                     │
            ┌────────┼────────┐
            ▼        ▼        ▼
       [ cli.py ] [ app_local.py ] [ /api/transpile + /api/extract + /api/pbip ]