Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
rhotz
New Member

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.

1 REPLY 1
Vijay_A_Verma
Super User
Super User

Would suggest that you cross-post this query in Power BI Desktop forum as well to get relevant help regarding driver issue. This forum is focussed more towards Power Query.

https://community.powerbi.com/t5/Desktop/bd-p/power-bi-designer 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors