Revit
The Revit template, available to all Vcad users, is good starting point for creating Power BI reports based on Revit models.
Report pages
The report template is divided in the following pages to showcase some of the possibilities when using Vcad:
- Summary
- Themes
- Markers
- Asset Details
- Ext Asset Detail
- Tree
- Model Data
Summary
The page offers a brief overview of the model structure and the extracted data.
If an elevated number of assets or properties have been extracted from the model, a warning will suggest possible actions to improve performance and link to additional resources.
Themes
The “Themes” page contains a rendering of the BIM model and three tables, which display theme colors based on: categories, families and symbols of the objects extracted from the Revit model.
The theme coloring option has been enabled for the custom visual in this page and the three color themes have been bound to the visual, allowing users to select which colors to apply to the model.
Markers
The “Markers” page contains a rendering of the BIM model with markers for each asset. The markers are automatically placed in the geometric center of each asset and are colored based on the family color.
The page also includes other visuals to filter assets and markers.
Asset Details
The main features of the “Asset Details” page are the rendering of the model and two related tables: Asset List and Property List.
The Asset List table contains all the extracted assets present in the model.
By selecting rows in the table, the model will be filtered and highlight the selected asset.
The Property List table presents all the extracted properties of the various assets in the model.
When the Assets List table is selected, the Property List table will display only the properties of the selected asset.
The report page also contains slicers and a search-bar to aid in finding the desired objects.
Ext Details
The “Ext Details” page focuses on the extended details extracted from the model.
The page is structured as the “Asset Details” page but the data reported in the tables comes from the “VCAD_ExtAsset” and “VCAD_ExtProperties” data-sets.
Tree
The “Tree” page contains a rendering of the model and a matrix visual showcasing the model tree structure.
Available data-sets
The Revit template will include various data-sets divided into folders. These tables contain all the data extracted from the BIM file:
VCAD_Data folder
The data-sets defined in the VCAD_Data folder constitute the core of the data extracted from the model.
VCAD_Assets
The VCAD_Assets table lists all the assets defined in the model.
The Table also contains the information of the parent asset as well as the Category, Family, and Symbol it belongs to.
VCAD_Properties
The VCAD_Properties table lists all the properties of every asset in the model.
The properties are normalized in the following columns: objectId, section, name, value.
VCAD_Levels
The VCAD_Levels table identifies what level each asset belongs to.
NOTE: The VCAD_Levels table will only be populated if the levels have been defined and the assets assigned in the Revit file.
VCAD_ModelProperties
The VCAD_ModelProperties table contains project level properties.
The properties are normalized in the following columns: objectId, section, name, value.
VCAD_Views
The VCAD_Views table lists all the views exported in the Revit model and details if they are 2D or 3D views.
VCAD_ExtAssets
The VCAD_ExtAssets table lists extended assets from the model.
This data-set can be useful to interact with the model on the category, family, or symbol level.
VCAD_ExtProperties
The VCAD_ExtProperties table lists all the properties of the extended asset in the model.
The properties are normalized in the following columns: objectId, section, name, value.
VCAD_ColorTables folder
The VCAD_ColorTables folder contains data-sets used to assign themes to catgories, families, and symbols. They are example data-sets, which may be deleted if not used.
VCAD_categoryColor
The data-set assigns a color to each category of the assets in the Revit model.
VCAD_familyColor
The data-set assigns a color to each family of the assets in the Revit model.
VCAD_symbolColor
The data-set assigns a color to each symbol of the assets in the Revit model.
