Hi,
With Powerbi and the ODBC connector for MongoDB from the mongoDB doc/site, when I try to retrieve the data from one of my collection (with only 2 documents, multiple object inside, multiple level of data)
The problem is the same via the “data navigator” or after the first evaluation in the list of data
Either the retrieval is very slow, few minutes and more or I get an error “Container unexpectedly exited with exit code 0xc0000005” with info from the mongodb driver / connector"
Another Collection with 16k lines is working fine but has no object in documents.
Are the conjunction between ODBC drivers and documents with multiple object could provoke this slow evaluation/error of the data retrieval ?
PowerBi Error Data :
Feedback Type:
Frown (Error)
Timestamp:
2025-01-07T10:19:29.7657733Z
Local Time:
2025-01-07T11:19:29.7657733+01:00
Session ID:
aed5ebff-26dc-4296-ae41-dee9b0c10391
Release:
November 2024
Product Version:
2.138.1452.0 (24.11) (x64)
Error Message:
Le conteneur s'est arrêté de façon inattendue avec le code 0xC0000005. PID : 72668.
Fonctionnalités utilisées : Odbc.DataSource/mdbodbc5a.dll/01.04.0005/MySQL/5.7.12 mongosqld v2.14.20.
Stack Trace:
Microsoft.Mashup.Host.Document.SerializedException
Microsoft.Mashup.Evaluator.Interface.ErrorException: Le conteneur s'est arrêté de façon inattendue avec le code 0xC0000005. PID : 72668.
Fonctionnalités utilisées : Odbc.DataSource/mdbodbc5a.dll/01.04.0005/MySQL/5.7.12 mongosqld v2.14.20. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: Le conteneur s'est arrêté de façon inattendue avec le code 0xC0000005. PID : 72668.
à Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
à Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
--- Fin de la trace de la pile d'exception interne ---
à Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
à Microsoft.Mashup.Evaluator.ChannelMessenger.Read(MessageChannel channel)
à Microsoft.Mashup.Evaluator.ChannelMessenger.MessageChannel.Read()
à Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
à Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
à Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_Value()
à Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_Value()
à Microsoft.Mashup.Host.Document.Preview.PreviewEvaluation.<>c__DisplayClass22_0.<StartEvaluation>b__0(EvaluationResult2`1 result)
Stack Trace Message:
Le conteneur s'est arrêté de façon inattendue avec le code 0xC0000005. PID : 72668.
Fonctionnalités utilisées : Odbc.DataSource/mdbodbc5a.dll/01.04.0005/MySQL/5.7.12 mongosqld v2.14.20.
Invocation Stack Trace:
à Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
à Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
à Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
à Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
à Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()
à Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
à Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>c__DisplayClass79_0.<OnAjaxException>b__0()
à Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
à System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
à System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
à System.Delegate.DynamicInvokeImpl(Object[] args)
à System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
à System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
à System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
à System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
à System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
à System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
à System.Windows.Forms.Control.InvokeMarshaledCallbacks()
à System.Windows.Forms.Control.WndProc(Message& m)
à System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
à System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
à System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
à System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
à System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
à System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
à System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
à Microsoft.Mashup.Client.UI.Windows.DialogWindowBase.ShowModal(IWindowHandle windowHandle)
à Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
à Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
à Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.NavigatorFloatingDialog.ShowEditLoad(IWindowHandle owner, ILegacyUIHost uiHost, Query query, ITelemetryService telemetryService, Boolean multiSelectionEnabledByDefault, ILearnedQueryImporterHost learnedQueryImporterHost, INavigatorSsoContextProvider ssoContextProvider)
à Microsoft.PowerBI.Client.Windows.PowerBIDataImporter.ShowNavigator(Query query)
à Microsoft.Mashup.Client.UI.Shared.DataImporter.ShowNavigatorOnSourceQuery(Query query, IEnumerable`1& importedQueries)
à Microsoft.Mashup.Client.UI.Shared.DataImporter.ImportNavigationSource(Query query)
à Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor)
à Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)
à Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c__DisplayClass90_0.<OnQuerySettingsResolved>b__0()
à Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
à System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
à System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
à System.Delegate.DynamicInvokeImpl(Object[] args)
à System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
à System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
à System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
à System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
à System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
à System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
à System.Windows.Forms.Control.InvokeMarshaledCallbacks()
à System.Windows.Forms.Control.WndProc(Message& m)
à System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
à System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
à System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
à System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
à System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
à System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
à System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
à Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
à Microsoft.PowerBI.Client.Program.<>c__DisplayClass7_0.<RunApplicationLegacy>b__0()
à Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
à Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
à Microsoft.PowerBI.Client.Program.RunApplicationLegacy(String[] args)
à Microsoft.PowerBI.Client.Program.Main(String[] args)
PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.138.1452.0","ModuleName":"","Component":"Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel","Error":"Microsoft.Mashup.Evaluator.Interface.ErrorException","MethodDef":"Read","ErrorOffset":"","ErrorCode":""}
OS Version:
Microsoft Windows NT 10.0.22631.0 (x64 fr-FR)
CLR Version:
4.8 or later [Release Number = 533320]
Peak Virtual Memory:
71.2 GB
Private Memory:
912 MB
Peak Working Set:
1.15 GB
IE Version:
11.1.22621.0
User ID:
faa57b24-fe43-420d-8bda-3901e8264ed8
Workbook Package Info:
1* - fr-FR, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.
Telemetry Enabled:
True
Snapshot Trace Logs:
C:\Users\xx\Microsoft\Power BI Desktop Store App\FrownSnapShot3ce08421-0491-4653-be8e-7e6470e12f53.zip
Model Default Mode:
Composite
Model Version:
PowerBI_V3
Performance Trace Logs:
C:\Users\xxx\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip
Enabled Preview Features:
PBI_sparklines
PBI_scorecardVisual
PBI_fieldParametersSuperSwitch
PBI_setLabelOnExportPdf
PBI_oneDriveSave
PBI_oneDriveShare
PBI_useModernPublishDialogs
PBI_gitIntegration
PBI_newCard
PBI_buttonSlicerAuthoring
PBI_EimLessElevatedUser
PBI_mobileAutoReportLayout
PBI_daxInlineCopilot
PBI_aiNarrativesVisual
PBI_generateMeasureDescriptionsButton
PBI_visualCalculationsAuthoring
PBI_desktopReportAuthoringCopilot
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_metricsArtifactsOnDesktop
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_onObject
PBI_odspSaveBackgroundUpload
PBI_publishDialogsSupportSubfolders
PBI_tmdlInDataset
PBI_enhancedReportFormat
PBI_directLakeRemoteModeling
PBI_advancedSlicerTypeList
PBI_textSlicer
PBI_qnaImproveLsdlCopilot
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
PowerBIUserFeedbackServices_IsReported:
True
DPI Scale:
125%
Supported Services:
Power BI
Formulas:
section Section1;
shared journey_list = [redacted]