Reply
JeffreyChou
Regular Visitor

(Refreshing power bi report connecting to Sqlite db)- Error message

Hi, all experts,

     I have a power bi report connecting with Sqlite database which located at the network drive, When using power bi desktop, everything can run smoothly, howerver, when I want to publish it to Power BI server and do schedule refresh, it showed the below error message. 

Error code:
SessionID: 49958275-b41a-4e65-9a1c-fbee81fca9cf

[0] -1055784932: DataSource.Error: ODBC: ERROR [HY000] unable to open database file (14). DataSourceKind = Odbc. DataSourcePath = database=\\na06\pro\PowerBI Pro\OES PowerBI\FAC\AMC\AMCEQStatus.db;dsn=SQLite3 Datasource;longnames=0;notxn=0;stepapi=0;syncpragma=NORMAL;timeout=1000. OdbcErrors = #table({"SQLState", "NativeError", "Message"}, {}). 。Exception from IDbCommand interface。

      For background information, BI server has installed ODBC driver for sqlite, however, the error message still showed. How can I solve the problem.

Jeffrey 

0 REPLIES 0
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)