📄️ Introduction
This section contains the documentation for the tables and columns in the Revit Data Model for Power BI.
📄️ BimDocument Table
The rows of this table are the BIM Documents located in VIM files. These can be individual files or groups of Revit, Navisworks, or IFC files. BIM Documents are sometimes referred to as models or links.
📄️ Category Table
_key
📄️ Element Table
The Element table is the most important data source at the heart of the data model. Whenever you count or select objects, it will be using the Element table.
📄️ Element - Elevation Table
This table is created to harmonize the elevations so they can be compared between Project Points and Survey Points.
📄️ Element - Project Table
This table is created to harmonize the elevations so they can be compared between Project Points and Survey Points.
📄️ Element - CompoundStructure Table
Compound Structures are layered elements like Floors, Roofs, Walls and Ceilings.
📄️ Element-In-System Table
_key
📄️ Element-In-Warning Table
_key
📄️ Element-PhaseFilter Table
_key
📄️ Element-View Table
Many of the Revit Camera parameters aim to replicate the original location, direction, angle and crop.
📄️ Family Table
_key
📄️ Family-Parameter Table
Element (Hidden)
📄️ FamilyInstance-Parameter Table
Element (Hidden)
📄️ FamilyType Table
Element (Hidden)
📄️ FamilyType-Parameter Table
Element (Hidden)
📄️ Instance-Level Table
If an element is hosted on a Level value, it will be linked to the levels in this table.
📄️ Instance-Room Table
The relationship between Room and Instance Elements. Every Element Instance that can be part of a room will be associated with this table if it is located within a room.
📄️ Instance-Workset Table
If an element is a Workset, it will be associate with this table.
📄️ Material-In-Element Table
Allows a breakdown of material Count, Area, and Volume per Element Instance.
📄️ Phases Table
_key
📄️ Unit Table
_key
📄️ VIM Table
The database can look at one or multiple merged VIM files. VIM files can contain multiple BIM models and VIM files can be merged. The attribute of each VIM file is listed below.