Forum Discussion

Levien's avatar
Levien
Icon for Advocate I rankAdvocate I
9 years ago
Solved

connecting a SQLite database

Hi,   I'm trying to connect to a (local) .db file, created in SQLite3. Anyone any idea how this could work out? Thanks & regards,   Levien
  • pkoetzing's avatar
    pkoetzing
    9 years ago

    Hi,

     

    You need to install a SQLite ODBC driver (look here: http://www.ch-werner.de/sqliteodbc) on your local machine. Then "Get Data" - "ODBC" and enter "database=C:\mysqlite.db" as connection string. This works at least for the PowerBI Desktop.

     

    /Peter

ColeStJohn's avatar
ColeStJohn
New Member
4 years ago

Just to add something to Peters response - I needed to modify slightly as follows:

DSN: none

DRIVER={SQLite3 ODBC Driver};Database=C:\MDL_DASHBOARD.db;

BieTii's avatar
BieTii
New Member
3 years ago

This works for me. Thanks