Forum Discussion

Levien's avatar
Levien
Advocate 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
Advocate 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

JSN's avatar
JSN
Frequent Visitor
4 years ago

Hi, thx for your hint!

How can I use this to be loaded from a folder source? To be more precise how I can I combine the DB files then using this ODBC driver?