Forum Discussion
Advocate Iconnecting a SQLite database
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
From my understanding SQLite is an embedded database and doesn't allow external connections.
SQLite can be an embedded database. But it does not need to be (only).
See earlier posts. The SQLite .db file is somewhere (in our case a storage server in the cloud for security reasons).
A specific machine (can be multiple machines) connects to that file via ODBC. For ODBC driver: look here: http://www.ch-werner.de/sqliteodbc.
All programs can connect to the SQLite database via ODBC on that machine (so Ms. Acces, Excel, PowerBi Desktop, etc.) and read and write to the SQLite database. (Yeah, succes)
The last step to make the PowerBi Cloud Service connect to the SQLite database is to install the gateway on the machine with the ODBC to SQLite. Test it, and all is done: you can automatically refresh your PowerBi information.
Necisities for auto refresh in the PowerBi Service: the user who installed the gateway needs to be logged on on the machine and the machine needs to be powered on offcourse. Try it, it really works.
It all has very little to do with PowerBi and most of it is about installing and connecting via ODBC. So i included a picture of my ODBC setup.
