Issue trying to deal with load huge excel DB (about 12MB and 299058 records + column heading)

grinaldi_jnj · ‎12-06-2023

Here below the ERROR LOG details

Feedback Type:

Frown (Error)

Error Message:

Errore

Stack Trace:

Microsoft.Mashup.Client.UI.Shared.ExceptionResultException

in Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)

in Microsoft.Mashup.Evaluator.RemoteEvaluationContainerFactory.Container.OnException(IMessageChannel channel, ExceptionMessage message)

in Microsoft.Mashup.Evaluator.MessageHandlers.<>c__DisplayClass3_0`1.<AddHandler>b__0(IMessageChannel channel, Message message)

in Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)

in Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

in Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)

in Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

in Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)

in Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)

in Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()

in Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()

in Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_SmallValue()

in Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

Stack Trace Message:

Errore

Invocation Stack Trace:

in Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()

in Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)

in Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)

in Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)

in Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()

in Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.SendAndMarshalExceptions(SynchronizationContext context, Action callback)

in Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)

in Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e)

in Microsoft.PowerBI.Client.Windows.Utilities.PowerBIFormUnexpectedExceptionHandler.HandleException(Exception e)

in Microsoft.Mashup.Client.UI.Shared.DataImporter.HandleImportEvaluationException(ExceptionResult exceptionView, Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor)

in Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor)

in Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination)

in Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c__DisplayClass89_0.<OnQuerySettingsResolved>b__0()

in Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

in Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass5_0.<Post>b__0(Object null)

in System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

in System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

in System.Delegate.DynamicInvokeImpl(Object[] args)

in System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)

in System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)

in System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

in System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

in System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

in System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)

in System.Windows.Forms.Control.InvokeMarshaledCallbacks()

in System.Windows.Forms.Control.WndProc(Message& m)

in System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

in System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

in System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

in System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

in System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)

in System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)

in System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)

in System.Windows.Forms.Application.RunDialog(Form form)

in System.Windows.Forms.Form.ShowDialog(IWin32Window owner)

in Microsoft.PowerBI.Client.Program.<>c.<RunApplication>b__6_8()

in Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)

in Microsoft.PowerBI.Client.Program.<>c__DisplayClass6_0.<RunApplication>b__0()

in Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()

in Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

in Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleExceptionsWithNestedTasks(IExceptionHandler exceptionHandler, Action action)

in Microsoft.PowerBI.Client.Program.RunApplication(String[] args)

in Microsoft.PowerBI.Client.Program.Main(String[] args)

PowerBINonFatalError:

{"AppName":"PBIDesktop","AppVersion":"2.123.742.0","ModuleName":"","Component":"Microsoft.Mashup.Evaluator.EvaluationHost","Error":"Microsoft.Mashup.Client.UI.Shared.ExceptionResultException","MethodDef":"OnException","ErrorOffset":"","ErrorCode":""}

Snapshot Trace Logs:

C:\Users\grinaldi\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot0330eff8-40de-4161-b9c8-b9fb406a8d7b.zip

Model Default Mode:

Empty

Model Version:

PowerBI_V1

Performance Trace Logs:

C:\Users\grinaldi\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:

PBI_shapeMapVisualEnabled

PBI_sparklines

PBI_scorecardVisual

PBI_NlToDax

PBI_fieldParametersSuperSwitch

PBI_setLabelOnExportPdf

PBI_dynamicFormatString

PBI_oneDriveSave

PBI_oneDriveShare

PBI_newCard

PBI_buttonSlicerAuthoring

Disabled Preview Features:

PBI_SpanishLinguisticsEnabled

PBI_qnaLiveConnect

PBI_b2bExternalDatasetSharing

PBI_enhancedTooltips

PBI_angularRls

PBI_onObject

PBI_backstageUI

PBI_gitIntegration

PBI_modelExplorer

PBI_daxQueryView

PBI_aiNarrativesVisual

PBI_qnaImproveLsdlCopilot

Enabled DirectQuery Options:

TreatHanaAsRelationalSource

Cloud:

GlobalCloud

ExceptionResultMessage:

Eccezione lanciata da un componente esterno.

PowerBIUserFeedbackServices_IsReported:

True

Formulas:

section Section1;

shared #"Rapporto Spesa DM per Azienda Sanitaria - Anni 2015-2021 - DPS - DB SpesaDM" = let

Origine = Excel.Workbook(File.Contents("D:\MdS (Spesa DM 2021)\Rapporto Spesa DM per Azienda Sanitaria - Anni 2015-2021 - DPS - DB SpesaDM.xlsb"), null, true)

in

Origine;

Anonymous · ‎12-07-2023

Hi @grinaldi_jnj

You connected to your excel through the built-in excel connector in PBI Desktop and then got an error reported during loading, right? Have you tried this feature before? If you load a small amount of data, can you load it successfully? What version of PBI Desktop are you currently using?

Best Regards,
Community Support Team _ Ailsa Tao

Issue trying to deal with load huge excel DB (about 12MB and 299058 records + column heading)