Forum Discussion
Unable to Connect to SQLite Cloud Database in Power BI Desktop
I am trying to connect to SQLite Cloud database @ https://sqlitecloud.io
I am using the ODBC Driver available at http://www.ch-werner.de/sqliteodbc/
The ODBC drive is working fine with the local Machine database but unable to fitch any data from SqliteCloud.
I am using the below in Power Query
Odbc.DataSource("driver={SQLite3 ODBC Driver};sqlitecloud://cx203tyyyhk.g3.sqlite.cloud:1234/chinook.sqlite?apikey=78783dfdfdfdfdxcxcxcxwewewe;dsn=SQLite3 Datasource", [HierarchicalNavigation=true])
Thanks in advance for your guidance.
Power Query only supports individual section members. You need to run separate scripts.
3 Replies
- lbendlin
Super User
There is no Power BI connector for this. You can use Python instead
Connecting to a Cluster | SQLite Cloud Docs
(You can run Python scripts in Power Query but they will require a personal gateway if you want to refresh in the service)
Thank your for the detail.
Is there any way to import / Link All Tables in one go using Python in Power Query?
Or we have to import / Link Tables one by one.
Thanks- lbendlin
Power Query only supports individual section members. You need to run separate scripts.
