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

pkoetzing's avatar
pkoetzing
Icon for Advocate III rankAdvocate III
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

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

Thanks Peter. I found that odbc driver earlier indeed, but was marked by Norton as unsafe. Tried anyway, works fine. Indeed, at the moment only on local file, let's see for the futur!

Best regards, Levien