Forum Discussion

rhotz's avatar
rhotz
New Member
4 years ago

SQLLITE3 LOAD - NO FUNCTION FOUND

Power BI Desktop (January 2021)

 

DataSource.Error: ODBC: ERROR [HY000] no such function: LN (1)
Detalhes:
DataSourceKind=Odbc
DataSourcePath=database=C:\Users\rhotz\Downloads\Investimento\Investimentos.db;dsn=SQLite3 Datasource
OdbcErrors=[Table]

 

The view it is attempting to load reads from another one which contains a LN function (natural log).

 

How can we fix? I am using the most recent sqliteodbc_w64 driver.

Need Help

5 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    You shouldn't need to specify both the database name and the dsn. Normally the dsn is enough.

     

    This sounds more like an ODBC error than a Power BI error.  Do you get the same issue when you access your SQLITE database from Excel?

    • rhotz's avatar
      rhotz
      New Member
      4 years ago

      I could not connect through Excel, despite many attempts. Is there any post/guide I could follow?

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        4 years ago

        Can you post a sanitized sample version of the SQLite db file?

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

    Hi, rhotz 

    Which version of the database are you currently using?

    LN function is not basic function in older versions of SQLite3.

     

    Best Regards,
    Community Support Team _ Eason

     

     

     

     

    • rhotz's avatar
      rhotz
      New Member
      4 years ago

      V 3.3.3

       

      I was not able to connect via Power Query in Excel.