Posts

All the articles I've posted.

• Inside metadata.sqlitedb: Tables, Columns, Measures & Relationships

  24 Feb, 2026

  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

  27 Jan, 2026

  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

  20 Jan, 2026

  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?

  13 Jan, 2026

  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.