Exporting a Revit Model with Tracer
This video reviews the new Tracer Exporter tool for Autodesk Revit. The addin enables user to selectively export Revit element categories to an open relational database file for BIM. The data can be used for analytical workflows with Power BI and other data-driven processes. The exporter exposes options for selecting 2D or 3D geometry and the ability to save export presets.
- Learn about the Tracer Export UI
- Learn about saving export presets
- Learn about geometry export options
- Learn how to filter Revit element categories for export
Visualizing 3D Revit Rooms in Power BI
This video provides an introduction in how to use the new 3D Tracer visual for Power BI. The 3D Power BI visual can be used to display 3D objects ‘on demand’ from data fields. Here we render 3D room objects that were exported from a Revit Building Information Model.
- Learn how to connect to a Tracer database file
- Learn how to import the Tracer 3D Visual
- Learn how to assign data to the Tracer 3D Visual
- Learn how the visual responds to other report elements.
Connecting Power BI to Revit Data
After exporting a Revit document to a SQLite file, Power Bi can connect to the file as a data source to access the tables and views.
- Set a Power BI data source to the SQLite file using ODBC.
- Review and set table relationships between the document, element, and parameters tables.
- Access a SQLite view containing element data.
Exploring Exported SQLite Revit Data
The Tracer adding for Revit exports element records to a SQLite relational database file. SQLite has many advantages for being a self-contained, lightweight, and fast database engine. The resultant SQLite export allows users to access the Revit data in various analysis tools.
- Exporting a Revit model to a SQLite database.
- Using the SQLite database browser to review data.
- Overview of key database tables.
- Querying prepared database views.
Visualizing Revit Rooms with Power BI Visual
Use the Tracer Power BI visual to create an interactive visual that displays a Revit document’s room boundaries with data.
- Set up a Power BI data source to the the RoomElement view.
- Import the Tracer Power BI visual.
- Configure the Power BI visual to display Revit room boundaries contained in the SQLite file.
Updating Revit Data in Power BI
Revit data can be easily updated in Power BI using the Tracer workflow. This tutorial covers how changes to a Revit file can be updated in Power BI quickly and easily to reflect the latest design.
- Make changes to your Revit model.
- Export the updated data.
- Refresh the data connection in Power BI
Exporting Elements in the Active Revit View
We are providing several Microsoft Power BI templates with our Tracer toolkit to demonstrate saving report layouts, data relationships, and connections. These are very useful in ‘jump starting’ your reporting without having to start from scratch! The templates are also useful to learn how Tracer’s Building Information Model data is structured for use within Power BI.
- Learn where to download some Tracer templates for Power BI
- Learn how to load 2D and 3D Revit data into a Power BI template
- Learn how to curate your data to communicate a story for your needs.
Combining Data From Multiple Revit Models in Power BI
The 3D Tracer visual can be used to display multiple 3D views using the “Views” input field. The result is an array of views that shows objects grouped in separate parallel 3D views. This is a good way to show components of a complex Revit assembly in multiple Power BI viewports.
- Learn how to ‘Append” multiple element database tables into a single table
- Learn how to combine 3D models into a single 3D visual in Power BI
- Learn how to index each model to filter and slice the model data