1. In Power BI, choose Get Data
In a new Power BI file, select “Get Data” to get a list of available data sources.
![](https://apps.provingground.io/wp-content/uploads/sites/2/2021/08/PowerBI-GetData.png)
2. Search and Select ODBC connection
Choose the ODBC connection as the data source. It is easily found by searching.
Note: The Tracer installer installs the required drivers and libraries that Power BI uses for SQLite ODBC connections.
![](https://apps.provingground.io/wp-content/uploads/sites/2/2021/08/PowerBI-ODBC-1024x359.png)
3. Set SQLite3 Datasource and Set Connection String
Under Data source name (DSN), select SQLite3 Datasource.
Under Advanced options, set a connection string using: database = PATH TO YOUR SQLITE FILE
Choose OK
![](https://apps.provingground.io/wp-content/uploads/sites/2/2021/08/PowerBI-ODBCSetup-1024x765.png)
4. Select Tables to Import into Power BI
After connecting, select the tables to import. The primary tables in the Revit exported SQLite data model are:
- Document
- Element
- ElementParameterInteger
- ElementParameterElementID
- ElementParameterNumber
- ElementParameterText
There are also a number of pre-defined SQLite views that leverage the above tables for convenient data access. For example: The “RoomElements” view contains a table of all room elements and parameter fields.
![](https://apps.provingground.io/wp-content/uploads/sites/2/2021/08/PowerBI-TableNavigator-1024x817.png)
5. Verify Table Relationships
Under the Power BI “Model”, review the table relationships. The following is a setup showing the one-to-many joins between the primary Revit exported SQLite tables.
![](https://apps.provingground.io/wp-content/uploads/sites/2/2021/08/PowerBI-Relationships-1024x605.png)