Archives
All the articles I've archived.
-
PBIX Parsing in Your Browser: Introducing PBIX.info
PBIX.info: a browser-based PBIX inspector built on WebAssembly. Local-first parsing, interactive diagrams, and shareable collaboration links.
-
How VertiPaq Sorts Rows to Maximize RLE Compression
How VertiPaq appears to use a greedy row-reordering algorithm to maximise RLE compression across all columns in a segment.
-
Reconstructing Column Data from .idf and .idfmeta
How VertiPaq stores column segments in .idf and .idfmeta files, and how those files combine to reconstruct imported table data from a PBIX file.
-
VertiPaq Dictionaries and Hash Indexes
How VertiPaq stores dictionaries and hash indexes inside a PBIX file, and how those structures help turn internal IDs back into readable values.
-
Parsing PBIX Files with Python (pbixray)
Extract tables, measures, M queries, and report metadata from any PBIX file using the open source Python library pbixray — no Power BI required.
-
Inside metadata.sqlitedb: Tables, Columns, Measures & Relationships
How metadata.sqlitedb inside a PBIX file exposes the semantic model as an embedded SQLite database, mirroring the same objects as TMSCHEMA DMVs.
-
The DataModel: Power BI's Embedded Analysis Services Engine
Power BI embeds a full Analysis Services Vertipaq engine inside every PBIX file. This article explains how the DataModel stream works and what it contains.
-
Inside the PBIX ZIP Archive
A PBIX file is a ZIP archive. Here's a map of every entry inside it — what each file does and how they relate to one another.
-
What Is a PBIX File?
An introduction to the .pbix file format — what it contains, how Power BI uses it, and why its internals matter for developers and data engineers.