Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi I am getting Error to connect with Firebird ODBC, this is the follow-up, could help ?, Thanks.
DataMashup.Trace Information: 24579 : {"Start":"2016-03-22T14:48:29.1724889Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","ProductVersion":"2.32.4307.641 (PBIDesktop)","ActivityId":"56f8700c-9561-4a0a-834c-91b4b695782e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1624,"Tid":1,"Duration":"00:00:00.0008407"}
DataMashup.Trace Error: 24579 : {"Start":"2016-03-22T14:48:29.1749686Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","Attempt":"0","MaxAttempt":"0","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: SUCCESS_WITH_INFO [01004] [ODBC Firebird Driver]Data truncated\r\nStackTrace:\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.LoadDiagnosticRecords(RetCode fetchRetcode)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.Fetch()\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.SyncColumnsPage(Byte* boundColumnsDataPtr)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.Read(OdbcStatementHandle statement, RowRange rowRange)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.Read(OdbcPage page)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.ExceptionHandlingPageReader.<>c__DisplayClass1a.<Read>b__19()\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.<>c__DisplayClass1.<InvokeWithoutRetry>b__0()\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 maxRetryAttempts, Func`1 action)\r\n\r\n\r\n","ProductVersion":"2.32.4307.641 (PBIDesktop)","ActivityId":"56f8700c-9561-4a0a-834c-91b4b695782e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1624,"Tid":1,"Duration":"00:00:00.0124140"}
DataMashup.Trace Error: 24579 : {"Start":"2016-03-22T14:48:29.1749521Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: SUCCESS_WITH_INFO [01004] [ODBC Firebird Driver]Data truncated\r\nStackTrace:\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.LoadDiagnosticRecords(RetCode fetchRetcode)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.Fetch()\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.SyncColumnsPage(Byte* boundColumnsDataPtr)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.Read(OdbcStatementHandle statement, RowRange rowRange)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.Read(OdbcPage page)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.ExceptionHandlingPageReader.<>c__DisplayClass1a.<Read>b__19()\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.<>c__DisplayClass1.<InvokeWithoutRetry>b__0()\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 maxRetryAttempts, Func`1 action)\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action)\r\n\r\n\r\n","ProductVersion":"2.32.4307.641 (PBIDesktop)","ActivityId":"56f8700c-9561-4a0a-834c-91b4b695782e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1624,"Tid":1,"Duration":"00:00:00.0129723"}
DataMashup.Trace Information: 24579 : {"Start":"2016-03-22T14:48:29.1749118Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","Attempt":"0","MaxAttempt":"0","ProductVersion":"2.32.4307.641 (PBIDesktop)","ActivityId":"56f8700c-9561-4a0a-834c-91b4b695782e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1624,"Tid":1,"Duration":"00:00:00.0130825"}
DataMashup.Trace Error: 24579 : {"Start":"2016-03-22T14:48:29.1748870Z","Action":"Engine/IO/Db/ODBC/RunWithRetry","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [DataSource.Error] ODBC: SUCCESS_WITH_INFO [01004] [ODBC Firebird Driver]Data truncated\r\nStackTrace:\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action)\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.InvokeWithoutRetry(Action action)\r\n en Microsoft.Mashup.Engine1.Library.Common.ProgressPageReader.Read(IPage page)\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.<>c__DisplayClass1.<InvokeWithoutRetry>b__0()\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 maxRetryAttempts, Func`1 action)\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action)\r\n\r\nInnerException\r\nException:\r\nExceptionType: Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: SUCCESS_WITH_INFO [01004] [ODBC Firebird Driver]Data truncated\r\nStackTrace:\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.LoadDiagnosticRecords(RetCode fetchRetcode)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.Fetch()\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.SyncColumnsPage(Byte* boundColumnsDataPtr)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.Read(OdbcStatementHandle statement, RowRange rowRange)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.Read(OdbcPage page)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.ExceptionHandlingPageReader.<>c__DisplayClass1a.<Read>b__19()\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.<>c__DisplayClass1.<InvokeWithoutRetry>b__0()\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 maxRetryAttempts, Func`1 action)\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action)\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.32.4307.641 (PBIDesktop)","ActivityId":"56f8700c-9561-4a0a-834c-91b4b695782e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1624,"Tid":1,"Duration":"00:00:00.0163615"}
DataMashup.Trace Warning: 24579 : {"Start":"2016-03-22T14:48:28.9102428Z","Action":"RemotePageReader/RunStub","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: [DataSource.Error] ODBC: SUCCESS_WITH_INFO [01004] [ODBC Firebird Driver]Data truncated\r\nStackTrace:\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action)\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.InvokeWithoutRetry(Action action)\r\n en Microsoft.Mashup.Engine1.Library.Common.ProgressPageReader.Read(IPage page)\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.<>c__DisplayClass1.<InvokeWithoutRetry>b__0()\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 maxRetryAttempts, Func`1 action)\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action)\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.InvokeWithoutRetry(Action action)\r\n en Microsoft.Mashup.Evaluator.RemotePageReader.<>c__DisplayClass7.<RunStub>b__0()\r\n en Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)\r\n\r\nInnerException\r\nException:\r\nExceptionType: Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: SUCCESS_WITH_INFO [01004] [ODBC Firebird Driver]Data truncated\r\nStackTrace:\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.LoadDiagnosticRecords(RetCode fetchRetcode)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.Fetch()\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.SyncColumnsPage(Byte* boundColumnsDataPtr)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.OdbcPage.Read(OdbcStatementHandle statement, RowRange rowRange)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcPageReader.Read(OdbcPage page)\r\n en Microsoft.Mashup.Engine1.Library.Odbc.OdbcDataSource.ExceptionHandlingPageReader.<>c__DisplayClass1a.<Read>b__19()\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.<>c__DisplayClass1.<InvokeWithoutRetry>b__0()\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.RunWithRetryGuard[T](Int32 maxRetryAttempts, Func`1 action)\r\n en Microsoft.Mashup.Engine1.Library.Common.DbExceptionHandler.Invoke[T](Int32 maxRetry, Func`1 action)\r\n\r\n\r\n\r\n\r\n","ProductVersion":"2.32.4307.641 (PBIDesktop)","ActivityId":"56f8700c-9561-4a0a-834c-91b4b695782e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1624,"Tid":1,"Duration":"00:00:00.2861357"}
DataMashup.Trace Information: 24579 : {"Start":"2016-03-22T14:48:28.6472857Z","Action":"RemoteDocumentEvaluator/Service/OnBeginGetResult","evaluationID":"1","ProductVersion":"2.32.4307.641 (PBIDesktop)","ActivityId":"56f8700c-9561-4a0a-834c-91b4b695782e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1624,"Tid":1,"Duration":"00:00:00.5491984"}
DataMashup.Trace Information: 24579 : {"Start":"2016-03-22T14:48:29.1968435Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","Exception":"Exception:\r\nExceptionType: System.IO.FileNotFoundException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: No se pudo encontrar el archivo 'C:\\Users\\Administrador\\AppData\\Local\\Temp\\2\\Power BI Desktop\\166946bb-142f-458a-be30-c0aa085df3d6\\Caches\\e32f5885-9b87-4beb-a47b-1a55dd44aa91\\e6395229-70f9-4d4a-9115-6718c26e4a23.dat'.\r\nStackTrace:\n en System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)\r\n en System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n en System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)\r\n en System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize)\r\n en System.IO.File.OpenFile(String path, FileAccess access, SafeFileHandle& handle)\r\n en System.IO.File.SetLastAccessTimeUtc(String path, DateTime lastAccessTimeUtc)\r\n en Microsoft.Mashup.EngineHost.Services.FileSystemAccessHelper.<>c__DisplayClass4.<IgnoringAccessExceptions>b__3()\r\n en Microsoft.Mashup.EngineHost.Services.FileSystemAccessHelper.TryIgnoringAccessExceptions[T](Func`1 func, Nullable`1 activityId, T& result, Exception& accessException)\r\n\r\n\r\n","ProductVersion":"2.32.4307.641 (PBIDesktop)","ActivityId":"56f8700c-9561-4a0a-834c-91b4b695782e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1624,"Tid":1,"Duration":"00:00:00.0003591"}
DataMashup.Trace Information: 24579 : {"Start":"2016-03-22T14:48:29.1972554Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","ProductVersion":"2.32.4307.641 (PBIDesktop)","ActivityId":"56f8700c-9561-4a0a-834c-91b4b695782e","Process":"Microsoft.Mashup.Container.NetFX40","Pid":1624,"Tid":1,"Duration":"00:00:00.0014135"}
Hi @JAVIER, we've done a related fix recently, it will be out in the next release. Can you check if the next PBI Desktop still has the same issue when it gets released?
@JAVIER I have successfully connected to firebird using firebird odbc in power bi desktop. Make sure you are using latest versin of PBI desktop. Have you checked your ODBC connection and make sure it is working. In PBI desktop are you using ODBC connector ? And then entering connection string or you have created DSN ?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
76 | |
61 | |
37 | |
33 |
User | Count |
---|---|
99 | |
56 | |
51 | |
42 | |
40 |