March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.