(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
