Power BI to SQLite3 DB in Linux Server

[Anonymous]

Hi Team,

Can you please let me know if it is possible to connect Power BI Desktop in my Windows laptop to a SQLite database in Linux Server?

I tried via the ODBC and am able to connect from Power BI to SQLite DB in my own Windows laptop but did not find a way to establish connection to SQLite DB in server. Is this possible?

I also would like to refresh data daily using data refresh option in Power BI Desktop.

Can you please help?

[v-xicai]

Hi @Anonymous ,

Currently, I can only find some links  as  amitchandak's suggestion about connecting to SQLite3 in local by ODBC connector, while not sure it will be ok for the scenario SQLite3 in server.

If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support , Scroll down and click "CREATE SUPPORT TICKET", or go to Issue forum  to get further help.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , is SQLite3 is accessible outside Linux machine, the port is open, the whitelist of ip is done if needed

refer

https://community.powerbi.com/t5/Power-Query/connecting-a-SQLite-database/td-p/224205

https://www.biinsight.com/visualise-sqlite-data-in-power-bi/

[Anonymous]

Thank you Amit. I referred these two links but couldn't find the solution. I am reading that SQLite DB is not a hosted DB so I am not sure if what I am trying is even possible?