ABF structure of files located under a datamodel file in PBIX. #PowerBI #tabular

ABF_tabular_file_types.md

{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