Tracer Documentation

  1. Home
  2. Docs
  3. Tracer Documentation
  4. Tracer 2D Power BI Visual
  5. HOW TO: Visualize 2D Revit Rooms with Power BI

HOW TO: Visualize 2D Revit Rooms with Power BI

1. Reference the RoomElements View Table from a SQLite DB

Get data from a Revit exported SQLite database. Select “Get Data” and choose ODBC.

From the DSN Options, select “SQLite3 Datasource”. Expand the Advanced Options menu and enter “database = full file path“.

If you are copying and pasting your file path from another location, be sure to remove any quotation marks. Then choose “Ok”.

In the table navigator, find the “RoomElements” view. Then select Load

2. Import the Tracer 2D Visual

Under the Visualizations menu, choose “Get More Visuals” and choose to “Import a visual from a file”

Navigate to the Tracer visual (installed under the Documents\Proving Ground\Tracer)

3. Place a Tracer 2D Visual onto the Report Canvas

Select the newly imported Tracer visual to place an instance of it on the report canvas.

4. Set the Geometry Fields with Room Location

Set the following Visual fields as follows from the RoomElements table:

  • Category: “Name”
  • Level: “Level:1”
  • Geometry: “Element Location”

To fully support visual cross-filtering, it is also important to set the “Summarized Geometry” field. This field should also used the “Element Location” field but should be set to be summarized using First, Last or other type.

5. Test a Slicer to Filter the Rooms Visual

Place a new “Slicer” visual and test filtering by the RoomElement Name field.

6. Test Filtering from another visual

Place a graph visual set with the RoomElement Name and a measure, such as Area.

Related Video Tutorial

How can we help?