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
Advocate IIIHi,
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
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
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?
If SQLite DB is in Linux server, is there a way to establish connection from Power BI Desktop in my windows machine to this SQLite DB in lunix server?
Not just establish connection but daily data refesh when clicked on refresh from Power BI desktop should also work?
Thank you