Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi, Everyone!
I have upgraded to the Power BI Desktop June 2021, but found for myself that there some bugs and decided to come back to earlier version. Uninstalled and installed older one, but now when I try to lauch older version I receive error (details on error below). I installed newest version again, but now I cannot refresh dataset, yesterday everything was fine (not on topic, but maybe someone faced it, getting error - Microsoft.PowerBI.OleDb is not registered).
Error when opening older version:
Feedback Type:
Frown (Error)
Error Message:
One or more errors occurred.
Stack Trace:
System.OutOfMemoryException
at System.Collections.Generic.List`1..ctor(Int32 capacity)
at Microsoft.Mashup.Evaluator.SerializedResourceKindInfo.Deserialize(IEngine engine, BinaryReader reader, BinaryReader localeReader)
at Microsoft.Mashup.EngineHost.Services.LibraryService.LibraryInfo.<>c__DisplayClass49_0.<Deserialize>b__0(BinaryReader r)
at Microsoft.Mashup.Common.BinaryReaderWriterExtensions.ReadArray[T](BinaryReader reader, Func`2 readItem)
at Microsoft.Mashup.EngineHost.Services.LibraryService.LibraryInfo.Deserialize(IEngine engine, LibraryService service, ILibrary library, Byte[] bytes)
at Microsoft.Mashup.EngineHost.Services.LibraryService.LibraryInfo.TryGetInfo(IEngine engine, LibraryService service, ILibrary library, LibraryInfo& info)
at Microsoft.Mashup.EngineHost.Services.LibraryService.GetLibraryInfo(ILibrary library)
at Microsoft.Mashup.EngineHost.Services.LibraryService.EnumerateAndLoadLibraries()
at Microsoft.Mashup.EngineHost.Services.LibraryService.Reinitialize(ILibraryProvider[] providers)
at Microsoft.Mashup.Client.UI.Shared.UiExtensibility.UiExtensionHost.LoadModules(Trace innerTrace, IList`1 binaryModules, ILibraryProvider[] providers)
at Microsoft.Mashup.Client.UI.Shared.UiExtensibility.UiExtensionHost.Activate(IList`1 libraryExtensions, IApplicationPaths applicationPaths, ILibraryProvider internalProvider, String remoteExtensionsUrl)
at Microsoft.Mashup.Client.UI.Shared.UiExtensibility.UiExtensionHostManager.RegisterAndActivateUiExtensionHost(UiExtensionHost uiExtensionHost, IList`1 libraryExtensions, IApplicationPaths applicationPaths, ILibraryProvider internalProvider, String remoteExtensionsUrl)
at Microsoft.PowerBI.Client.Windows.PowerQueryExtensionsLoader.<Load>b__11_0()
at System.Threading.Tasks.Task.Execute()
Stack Trace Message:
One or more errors occurred.
Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass15_0.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.PowerBI.Client.Windows.Utilities.UIBlockingAwareExceptionHandler.HandleException(Exception e)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Delegate.DynamicInvokeImpl(Object[] args)
at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_0.<Main>b__1()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)
PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.92.1067.0","ModuleName":"Microsoft.MashupEngine.dll","Component":"Microsoft.Mashup.Evaluator.SerializedResourceKindInfo","Error":"System.OutOfMemoryException","MethodDef":"Deserialize","ErrorOffset":"139"}
InnerException0.Stack Trace Message:
Array dimensions exceeded supported range.
InnerException0.Stack Trace:
at System.Collections.Generic.List`1..ctor(Int32 capacity)
at Microsoft.Mashup.Evaluator.SerializedResourceKindInfo.Deserialize(IEngine engine, BinaryReader reader, BinaryReader localeReader)
at Microsoft.Mashup.EngineHost.Services.LibraryService.LibraryInfo.<>c__DisplayClass49_0.<Deserialize>b__0(BinaryReader r)
at Microsoft.Mashup.Common.BinaryReaderWriterExtensions.ReadArray[T](BinaryReader reader, Func`2 readItem)
at Microsoft.Mashup.EngineHost.Services.LibraryService.LibraryInfo.Deserialize(IEngine engine, LibraryService service, ILibrary library, Byte[] bytes)
at Microsoft.Mashup.EngineHost.Services.LibraryService.LibraryInfo.TryGetInfo(IEngine engine, LibraryService service, ILibrary library, LibraryInfo& info)
at Microsoft.Mashup.EngineHost.Services.LibraryService.GetLibraryInfo(ILibrary library)
at Microsoft.Mashup.EngineHost.Services.LibraryService.EnumerateAndLoadLibraries()
at Microsoft.Mashup.EngineHost.Services.LibraryService.Reinitialize(ILibraryProvider[] providers)
at Microsoft.Mashup.Client.UI.Shared.UiExtensibility.UiExtensionHost.LoadModules(Trace innerTrace, IList`1 binaryModules, ILibraryProvider[] providers)
at Microsoft.Mashup.Client.UI.Shared.UiExtensibility.UiExtensionHost.Activate(IList`1 libraryExtensions, IApplicationPaths applicationPaths, ILibraryProvider internalProvider, String remoteExtensionsUrl)
at Microsoft.Mashup.Client.UI.Shared.UiExtensibility.UiExtensionHostManager.RegisterAndActivateUiExtensionHost(UiExtensionHost uiExtensionHost, IList`1 libraryExtensions, IApplicationPaths applicationPaths, ILibraryProvider internalProvider, String remoteExtensionsUrl)
at Microsoft.PowerBI.Client.Windows.PowerQueryExtensionsLoader.<Load>b__11_0()
at System.Threading.Tasks.Task.Execute()
InnerException0.Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix)
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e)
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass15_0.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.PowerBI.Client.Windows.Utilities.UIBlockingAwareExceptionHandler.HandleException(Exception e)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Delegate.DynamicInvokeImpl(Object[] args)
at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_0.<Main>b__1()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)
Snapshot Trace Logs:
C:\Users\liudm\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot3624c0be-1d7c-412e-938d-3576f454d599.zip
Model Default Mode:
Empty
Model Version:
PowerBI_V1
Performance Trace Logs:
C:\Users\liudm\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Enabled Preview Features:
PBI_JsonTableInference
PBI_NewWebTableInference
PBI_ImportTextByExample
PBI_ExcelTableInference
PBI_eimInformationProtectionForDesktop
PBI_newFieldList
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_compositeModelsOverAS
PBI_narrativeTextBox
PBI_dynamicParameters
PBI_anomalyDetection
PBI_cartesianMultiplesAuthoring
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
PowerBIUserFeedbackServices_IsReported:
True
Formulas:
section Section1;
Many thanks in advance!
Solved! Go to Solution.
Hi @Anonymous
If you update Power BI Desktop from Microsoft Store App, I suggest you update Power BI Desktop from Microsoft Download Center directly. And try launching it via Run as administrator.
If this error still occurs, try resolutions from this document: Resolve issues when starting Power BI Desktop - Power BI | Microsoft Docs
Other reference: Power BI Error | Paperless Help Center
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Hi @Anonymous
If you update Power BI Desktop from Microsoft Store App, I suggest you update Power BI Desktop from Microsoft Download Center directly. And try launching it via Run as administrator.
If this error still occurs, try resolutions from this document: Resolve issues when starting Power BI Desktop - Power BI | Microsoft Docs
Other reference: Power BI Error | Paperless Help Center
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
I always use installation from Microsoft Download Center. And I have tried to install, launch it as administrator before asking for help.
With Microsoft.PowerBI.OleDb is not registered Microsoft Access Database Engine 2010 manual installation helped.
Nevertheless, thank you for the answer!
@Anonymous Hi i have the same issue. I updated to July version and i couldnt get into my pbix. I tried downgraded versions now i cant even open BI and having errors such as 'one or more errors occured' and array dimension errors. How did you get it to work? I am kind of stuck now. Thanks
Hi! Just started using new version. If with newest version you having "Microsoft.PowerBI.OleDb is not registered" error you should install manually Microsoft Access Database Engine 2010.
@Anonymous @Thanks for getting back to me. I don’t have that error msg but I’ll try installing db engine. Thanks!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
106 | |
99 | |
98 | |
38 | |
37 |
User | Count |
---|---|
158 | |
124 | |
75 | |
74 | |
63 |