Tracer Documentation

⌘K
  1. Home
  2. Docs
  3. Tracer Documentation
  4. Troubleshooting
  5. POWER BI ISSUE: Power BI won’t connect to SQLite and gives an ODBC Error

POWER BI ISSUE: Power BI won’t connect to SQLite and gives an ODBC Error

Power BI gives me an error when trying to connect to SQLite.

  • When connecting to a SQLite database, Power BI fails to connect with ERROR [IM006][Microsoft][ODBC Driver Manager] Driver’s SQLSetConnectAttr failed.
Problem
  • The ODBC driver is failing to resolve the connection to the SQLite database file.
Solution(s)
  • Ensure that the SQLite ODBC drivers are installed.
  • When connecting using ODBC, ensure you are using the “SQLite3 Datasource” for the DSN
  • Esnure that you are using the full file path (including file name and extension)

How can we help?