Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

ODBC: Error while trying to connect

Hi All, I'm a newbie to Power BI (Desktop) and first time trying to connect to an SQLite database. I set up the connection to the database by following steps provided here: https://www.biinsight.c...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Thanks very much for your reply and assistance.

    I'm still trying to sort it out but I'm sure it just what you suggested.

    🙂

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Based on SQL lite version check the Driver version. Typically "out of memory" ERROR should come when a query runs. It is coming at a time connection so seems like a correct driver issue.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks very much for your help!

I'll investigate your suggestion

Thanks

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, Anonymous 

    I'm sorry. I can't reproduce your issue.I check all steps in the document your mentioned ,everything works well in my current environment.

    As mentioned by amitchandak  ,please check the version of your powerbi desktop and  Sqlite ODBC driver.Make sure you install the right versions of the driver ( x32 bit or x64).

     

    You aslo can  raise it to the support team for better advice.

     

    Best Regards,
    Community Support Team _ Eason

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks very much for your reply and assistance.

      I'm still trying to sort it out but I'm sure it just what you suggested.

      🙂