European Microsoft Fabric Community Conference
The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Register Now
Hi veryone,
I am trying to connec to an Access database from Power BI, and I am having the next issue:
"Unexpected error
An external componext produced an exception
Feedback Type:
Frown (Error)
Timestamp:
2018-11-25T11:02:36.6461974Z
Local Time:
2018-11-25T12:02:36.6461974+01:00
Session ID:
811f5923-68a9-4071-827f-edbb7fe43ce6
Release:
November 2018
Product Version:
2.64.5285.741 (18.11) (x64)
Error Message:
Un componente externo produjo una excepción.
Stack Trace:
Microsoft.Mashup.Evaluator.Interface.ErrorException: Un componente externo produjo una excepción. ---> System.Runtime.InteropServices.SEHException: Un componente externo produjo una excepción. ---> System.Runtime.InteropServices.SEHException: Un componente externo produjo una excepción.
en System.Data.OleDb.DataSourceWrapper.InitializeAndCreateSession(OleDbConnectionString constr, SessionWrapper& sessionWrapper)
en System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
en System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
en System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
en System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
en System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
en System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
en System.Data.OleDb.OleDbConnection.Open()
en Microsoft.Mashup.Engine1.Library.Common.TracingDbConnection.<Open>b__0(IHostTrace trace)
en Microsoft.Mashup.Engine1.Library.Common.Tracer.<>c__DisplayClass4.<TracePerformance>b__3(IHostTrace trace)
en Microsoft.Mashup.Engine1.Library.Common.Tracer.TracePerformance[T](String method, Func`2 func)
en Microsoft.Mashup.Engine1.Library.Common.TracingDbConnection.Open()
en Microsoft.Mashup.Engine1.Library.Common.WrappedDbConnection.Open()
en Microsoft.Mashup.Engine1.Library.Access.AccessEnvironment.AceMutexConnection.Open()
en Microsoft.Mashup.Engine1.Library.Common.DbExtensions.<>c__DisplayClass1.<Open>b__0()
en Microsoft.Mashup.Engine1.Library.Access.AccessEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action)
en Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.<LoadServerVersion>b__8()
en Microsoft.Mashup.Engine1.Library.Access.AccessEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action)
en Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.LoadCachedServerVersion()
en Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.CreateConnection()
en Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.<>c__DisplayClass45.<GetSchemaTable>b__41()
en Microsoft.Mashup.Engine1.Library.Access.AccessEnvironment.ConvertDbExceptions[T](IResource resource, Func`1 action)
en Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.GetSchemaTable(Func`2 loader, Boolean openConnection, String collectionName, String[] restrictions)
en Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.GetTables()
en Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.<GetTableTypes>d__9.MoveNext()
en Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.LoadTypeCatalog()
en Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.LoadCatalog()
en Microsoft.Mashup.Engine1.Library.Common.DbEnvironment.get_NavigationPropertiesRecord()
en Microsoft.Mashup.Engine1.Library.Common.DbCatalogTableValue.GetEnumerator()
en Microsoft.Mashup.Engine1.Language.Query.SkipTakeEnumerable.GetEnumerator()
en Microsoft.Mashup.Engine1.Language.Query.QueryTableValue.GetEnumerator()
en Microsoft.Mashup.Engine1.Runtime.TableValue.Microsoft.Mashup.Engine.Interface.ITableValue.GetEnumerator()
en Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.SerializeRows(Int32 count)
en Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.get_SmallValue()
en Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
en Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass5.<RunStub>b__3()
en Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
--- Fin del seguimiento de la pila de la excepción interna ---
en Microsoft.Mashup.Evaluator.EvaluationHost.<>c__DisplayClass7.<TryReportException>b__6()
en Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IEngineHost host, IHostTrace trace, Action action)
en Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception)
en Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
en Microsoft.Mashup.Evaluator.RemotePreviewValueSource.RunStub(IEngineHost engineHost, IMessageChannel channel, Func`1 getPreviewValueSource)
en Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass1e`1.<OnBeginGetResult>b__1b()
en Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
en Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)
en Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
en Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
en Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
en Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
en Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
en Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
en Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
en Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
en Microsoft.Mashup.Evaluator.EvaluationHost.Run()
en Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)
en Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)
en Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args)
--- Fin del seguimiento de la pila de la excepción interna ---
en Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
en Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
en Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
en Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
en Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
en Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
en Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
en Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()
en Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
en Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)
Invocation Stack Trace:
en Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
en Microsoft.Mashup.Client.UI.Shared.DataImporter.HandleImportEvaluationException(ExceptionResult exceptionView, Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor)
en Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor)
en Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)
en Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c__DisplayClass20.<OnQuerySettingsResolved>b__1d()
en Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
en System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
en System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
en System.Delegate.DynamicInvokeImpl(Object[] args)
en System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
en System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
en System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
en System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
en System.Windows.Forms.Control.InvokeMarshaledCallbacks()
en System.Windows.Forms.Control.WndProc(Message& m)
en System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
en System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
en System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
en System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
en System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
en System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
en System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
en Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__FabricatedMethod8(IWindowHandle )
en Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
en Microsoft.PowerBI.Client.Program.<>c__DisplayClass10.<Main>b__0()
en Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass7.<HandleExceptionsWithNestedTasks>b__6()
en Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
en Microsoft.PowerBI.Client.Program.Main(String[] args)
OS Version:
Microsoft Windows NT 10.0.17134.0 (x64 es-ES)
CLR Version:
4.7 or later [Release Number = 461808]
Peak Virtual Memory:
38.1 GB
Private Memory:
363 MB
Peak Working Set:
472 MB
IE Version:
11.407.17134.0
User ID:
dcc4a205-51c7-4323-84ed-12d13e90e40f
Workbook Package Info:
1* - es-ES, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.
Telemetry Enabled:
True
Model Default Mode:
Empty
Snapshot Trace Logs:
C:\Users\sierr\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot203272699.zip
Performance Trace Logs:
C:\Users\sierr\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
Disabled Preview Features:
MIntellisense
PBI_PdfImport
PBI_ColumnProfiling
PBI_variationUIChange
PBI_PythonSupportEnabled
PBI_showIncrementalRefreshPolicy
PBI_showManageAggregations
PBI_FuzzyMatching
PBI_EnableWebDiagramView
PBI_improvedFilterExperience
Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
100%
Supported Services:
Power BI
Formulas:
section Section1;
shared #"WorldWideImporters (Español)" = let
Origen = Access.Database(File.Contents("D:\WorldWideImporters (Español).accdb"), [CreateNavigationProperties=true])
in
Origen;
Anyone having the same problem? Someone with a solution?
Thanks a lot in advance!
Chema Ortega
Good afternoon!
The way I found to solve this, there are two options:
Note: In my case, whenever I upgrade the Power BI Desjtop version, this type of connection is intermittent !!!
1. Reinstall (AccessDatabaseEngine_x64.exe)
If no...
1. Uninstall / Install Power BI
2. Reinstall (AccessDatabaseEngine_x64.exe)
In my case it has worked perfectly when the error occurs !!!
Hope this helps!!!
Good afternoon!
The way I found to solve this, there are two options:
Note: In my case, whenever I upgrade the Power BI Desjtop version, this type of connection is intermittent !!!
1. Reinstall (AccessDatabaseEngine_x64.exe)
If no...
1. Uninstall / Install Power BI
2. Reinstall (AccessDatabaseEngine_x64.exe)
In my case it has worked perfectly when the error occurs !!!
Hope this helps!!!
Hi Chema,
The bit version mismatch could be a problem. Please refer to
power-bi/desktop-access-database-errors
. If it's possible for you to share a little sample? Please don't share sensitive data.
Best Regards,
Dale
Hi
@Chema_Ortega
,
I would suggest you file a support ticket
here
. It's free if you have a Pro licence.
Best Regards,
Dale
Power BI Monthly Update - July 2024
Check out the July 2024 Power BI update to learn about new features.
Fabric Community Update - June 2024
Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.
