https://community.fabric.microsoft.com/t5/Report-Server/Refreshing-power-bi-report-connecting-to-Sqlite-db-Error-message/m-p/3309625#M30327 <P><SPAN>Hi, all experts,<BR /><BR />&nbsp; &nbsp; &nbsp;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&nbsp;publish it to Power BI server and do schedule refresh, it showed the below error message.&nbsp;<BR /><BR /><STRONG>Error code:</STRONG><BR />SessionID: 49958275-b41a-4e65-9a1c-fbee81fca9cf</SPAN><BR /><SPAN>[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。<BR /><BR />&nbsp; &nbsp; &nbsp; For background information, BI server has installed ODBC driver for sqlite, however, the error message still showed. How can I solve the problem.<BR /><BR />Jeffrey&nbsp;<BR /><BR /></SPAN></P> Fri, 30 Jun 2023 07:24:22 GMT JeffreyChou 2023-06-30T07:24:22Z https://community.fabric.microsoft.com/t5/Report-Server/Refreshing-power-bi-report-connecting-to-Sqlite-db-Error-message/m-p/3309625#M30327 <P><SPAN>Hi, all experts,<BR /><BR />&nbsp; &nbsp; &nbsp;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&nbsp;publish it to Power BI server and do schedule refresh, it showed the below error message.&nbsp;<BR /><BR /><STRONG>Error code:</STRONG><BR />SessionID: 49958275-b41a-4e65-9a1c-fbee81fca9cf</SPAN><BR /><SPAN>[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。<BR /><BR />&nbsp; &nbsp; &nbsp; For background information, BI server has installed ODBC driver for sqlite, however, the error message still showed. How can I solve the problem.<BR /><BR />Jeffrey&nbsp;<BR /><BR /></SPAN></P> Fri, 30 Jun 2023 07:24:22 GMT https://community.fabric.microsoft.com/t5/Report-Server/Refreshing-power-bi-report-connecting-to-Sqlite-db-Error-message/m-p/3309625#M30327 JeffreyChou 2023-06-30T07:24:22Z