1. Reference the RoomElements View Table from a SQLite DB
Get data from a Revit exported SQLite database. Select “Get Data” and choose ODBC.
![](/wp-content/uploads/sites/2/2022/07/Get-Data-and-Select-ODBC-1024x694.png)
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”.
![](/wp-content/uploads/sites/2/2022/07/DSN-Advanced-Options-Connection-String.png)
In the table navigator, find the “RoomElements” view. Then select Load
![](/wp-content/uploads/sites/2/2022/07/nav-room-elements-1.png)
2. Import the Tracer 2D Visual
Under the Visualizations menu, choose “Get More Visuals” and choose to “Import a visual from a file”
![](/wp-content/uploads/sites/2/2022/07/Get-More-Visuals.png)
Navigate to the Tracer visual (installed under the Documents\Proving Ground\Tracer)
![](https://apps.provingground.io/wp-content/uploads/sites/2/2021/08/PowerBI-FindTracerVisual.png)
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.
![](https://apps.provingground.io/wp-content/uploads/sites/2/2021/08/PowerBI-PlaceTracerVisual-1024x694.png)
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.
![](https://apps.provingground.io/wp-content/uploads/sites/2/2021/08/PowerBI-SummaraizedGeometryTracer-647x1024.png)
5. Test a Slicer to Filter the Rooms Visual
Place a new “Slicer” visual and test filtering by the RoomElement Name field.
![](https://apps.provingground.io/wp-content/uploads/sites/2/2021/08/PowerBI-SlicerTracerRoomsVisual-1-1024x571.png)
6. Test Filtering from another visual
Place a graph visual set with the RoomElement Name and a measure, such as Area.
![](https://apps.provingground.io/wp-content/uploads/sites/2/2021/08/PowerBI-FilterTracerRoomsVisual-1024x828.png)