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\Inves...
Need Help
lbendlin's avatar
lbendlin
Super 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
    Super User
    4 years ago

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