1. Home
  2. Docs
  3. Tracer v1.0 Documentation
  4. HOW TO: Use SQLite as a Power BI Data Source

HOW TO: Use SQLite as a Power BI Data Source

1. In Power BI, choose Get Data

In a new Power BI file, select “Get Data” to get a list of available data sources.

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.

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

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.

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.


Related Video Tutorial

How can we help?