Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power BI to SQLite3 DB in Linux Server

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?

 

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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?

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    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.