Skip to content

Instantly share code, notes, and snippets.

@Hugoberry
Last active September 6, 2023 15:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Hugoberry/8e1e36a8e7d7883651950a56570db726 to your computer and use it in GitHub Desktop.
Save Hugoberry/8e1e36a8e7d7883651950a56570db726 to your computer and use it in GitHub Desktop.
ABF structure of files located under a datamodel file in PBIX. #PowerBI #tabular

{Table} ({TableID}).tbl folders contains the following

  • #.{Table} ({TableID}).Column ({ColumnID}).dictionary file for all the HASH encoded columns
  • #.H${Table} ({TableID})${Column} ({ColumnID}).hidx hash index files for all the VALUE encoded columns
  • {PartitionID}.prt partition folder with:
    • #.{Table} ({TableID).{Column} ({ColumnID}).0.idf column data storage file
    • #.{Table} ({TableID).{Column} ({ColumnID}).0.idfmeta column data storage metadata file

H${Table} ({TableID})${Column} ({ColumnID})$({SystemTableID}).tbl hierarchy folders

  • {PartitionID}.prt
    • #.H${Table} ({TableID})$Column ({ColumnID}).{ID_TO_POS|POS_TO_ID}.0.idf Column Hierarchy Position–to–Identifier or Identifier–to–PositionFile
    • #.H${Table} ({TableID})$Column ({ColumnID}).{ID_TO_POS|POS_TO_ID}.0.idfmeta

R${Table} ({TableID})${Relationship} ({RelationsipID})$({SystemTableID}).tbl relationship folders

  • {PartitionID}.prt
    • #.R${Table} ({TableID})${Relationship} ({RelationsipID}).INDEX.0.idf Relationship Index File
    • #.R${Table} ({TableID})${Relationship} ({RelationsipID}).INDEX.0.idfmeta

U${Table} ({TableID})${Hiearchy} ({HierarchyID})$({SystemTableID}).tbl user defined hierarchy folders

  • {PartitionID}.prt
    • U${Table} ({TableID})${Hiearchy} ({HierarchyID}).{CHILD_COUNT|FIRST_CHILD_POS|MULTI_LEVEL_ID|PARENT_POS}.0.idf
    • U${Table} ({TableID})${Hiearchy} ({HierarchyID}).{CHILD_COUNT|FIRST_CHILD_POS|MULTI_LEVEL_ID|PARENT_POS}.0.idfmeta

# an internal version number that is assigned by the system to each version of this object. This version number does not have to match the version number of other objects in the same model.

.0. is the segment number

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment