Forum Discussion
Solved
Are you able to Direct Query a SQLite database or does it have to be a full SQL Database source?
Basically the title. I was looking into setting up a SQLite database for some small scale live data query solutions. I would like to know if Direct Query would work for both the desktop and publishe...
Hi powerjey ,
You can take a look at following links about use custom data connector to achieve odbc directquery:
Enabling direct query for a data source via an odbc driver
Enabling Direct Query for an ODBC based connector
And refer the following links:
https://www.biinsight.com/visualise-sqlite-data-in-power-bi/
Best Regards
Lucien
Hi powerjey ,
You can take a look at following links about use custom data connector to achieve odbc directquery:
Enabling direct query for a data source via an odbc driver
Enabling Direct Query for an ODBC based connector
And refer the following links:
https://www.biinsight.com/visualise-sqlite-data-in-power-bi/
Best Regards
Lucien