Power BI File Parsing

Parse Power BI files (.pbix) into JSON metadata, DAX measures, and CSV data exports using multi-method extraction.

Usage

Run the parsing script directly:

./scripts/parse_pbix.py <path_to_file.pbix> <output_dir>

Example:

./scripts/parse_pbix.py ~/analytics/report.pbix ./parsed/

The script uses 2 extraction methods:

• pbixray - Metadata, measures, relationships
• zipfile - Raw file structure (debugging)

Output Structure

output_dir/
├── file.pbix/
│   ├── parsing_summary.json
│   ├── pbixray/
│   │   ├── model.json
│   │   ├── measures.json
│   │   ├── tables/
│   │   │   ├── Table1.csv
│   │   │   └── Table2.csv
│   │   └── relationships.json
│   └── zipfile/
│       └── structure.json

Script Features

• Extracts semantic model structure (tables, measures, relationships)
• Exports tables as CSV files for data access
• Provides DAX expressions in readable format
• Captures data model relationships and dependencies
• Works on Linux (no Windows Power BI dependency)

Method Selection

• pbixray - Primary method for metadata and model structure
• zipfile - Debugging fallback for raw file inspection