cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chema_Ortega
Helper III
Helper III

Access database connection error with Power BI

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
1 ACCEPTED SOLUTION
apods1979
Helper I
Helper I

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!!!

View solution in original post

10 REPLIES 10
apods1979
Helper I
Helper I

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!!!

View solution in original post

Thanks a lot Apods! great!!!

v-jiascu-msft
Microsoft
Microsoft

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

64.JPG

 

Thanks a lot, Dale!

Hi @Chema_Ortega,

 

I would suggest you file a support ticket here. It's free if you have a Pro licence. 

create-ATicket

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks a lot, Dale!!!!

 

Best regards,

 

Chema

DaveB
New Member

Chema - For what it's worth, I was challenges connecting to Access db with the Power BI 64 bit version ... I changed to 32 bit version and now connect fine.

 

DaveB

Thanks a lot, Dave! I need the 64 bit version...

Hi Dave,

 

I have evrything arranged in 64 bits: Office, Power BI, Acces, Excel, etc. I think the solution is not going back to 32. Thanks a lot anyway!

 

Best regards,

 

Chema

Hi Dave,

 

Thanks a lot. I am currently working with 64 bits in both programs. No option is going back to 32 bits, sorry.

 

Thanks a ot!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors