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.