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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Yeah Peter that will work on a desktop only because its embedded.  If you want to publish online and set up a refresh, you'll be out of luck

pkoetzing's avatar
pkoetzing
Icon for Advocate III rankAdvocate III
9 years ago

Yep - I realized that. But what do you actually mean by "embedded"? The sqlite.db is just a file. Of cause you need to have the proper protocol to understand the data - and this might not be obvious to the PBI Service, since sqlite isn't directly supported. But the same issue occurs with Microsoft Access databases and I actually expected the PBI Service to know how to handle their own proprietary format?