1. Home
  2. Docs
  3. Tracer v1.0 Documentation
  4. HOW TO: Review the Sample Power BI Template

HOW TO: Review the Sample Power BI Template

Summary

After a Tracer Revit export is complete, a sample template is created alongside the Power BI file. The file contains several example visuals connected to the SQLite database schema.

Here is how to use the template with the database file.


1. Open the Power BI Template

Double-click to open the Power BI template file (*.pbit)

2. Provide the file path to your SQLite DB file

Copy and paste the path to the SQLite database file (*.db). and click load.

3. Connect through ODBC Form

Power BI will prompt you to connect to the file from an ODBC form. Be sure to select “Default or Custom” and click “Connect”.

This is a default Power BI prompt. No password or connection string is required.

4. Wait for Data to Load

Power BI will load the data source. The load time will vary based on the size for your SQLite database file.

5. Review the Power BI Report and Loaded Data

After the data is loaded, Power BI will load the visuals. A Tracer visual is pre-placed in the report displaying room and element data.


Related Video Tutorial

How can we help?