Forum Discussion

timmcn's avatar
timmcn
Regular Visitor
10 years ago

Import Excel Workbook Content Unexpected Error

Hi,   Has anybody come across "Unexpected Error - Object not set to an instance of an object" when trying to import Excel Workbook Content?   I tried to idenitfy the issue through process of elim...
Need Help
cikuItreti's avatar
cikuItreti
New Member
10 years ago

Hi Tim,

 

usually when you see an "Unexpected Error" window you should be able to send us a frown containing all the information needed for us to be able to follow up. Moreover, in the same dialog there should be a "Copy Details" link. You can click on it to copy the error information into the clipboard then here.

 

  • timmcn's avatar
    timmcn
    Regular Visitor
    10 years ago

    Hi,

     

    I've sent the frown.  The details are below:

     

    Timestamp:
    2016-05-03T07:10:57.6346940Z

    Local Time:
    2016-05-03T17:10:57.6346940+10:00

    Product Version:
    2.34.4372.322 (PBIDesktop) (x64)

    Release:
    April 2016

    IE Version:
    11.212.10586.0

    OS Version:
    Microsoft Windows NT 6.2.9200.0 (x64 en-GB)

    CLR Version:
    4.6.1 or later [Release Number = 394254]

    Workbook Package Info:
    1* - en-AU, fastCombine: Disabled.

    Working set:
    456 MB

    Peak Virtual Memory:
    33.9 GB

    Screenshot:


    Error Message:
    Object reference not set to an instance of an object.

    Stack Trace:
    System.NullReferenceException: Object reference not set to an instance of an object.
    at Microsoft.PowerBI.Client.Windows.Storage.ExcelImporter.MapLinkedTablesToExcelTables(Package zipPackage)
    at Microsoft.PowerBI.Client.Windows.Storage.ExcelImporter.<>c__DisplayClass1.<CreateReportAsync>b__0()
    at System.Threading.Tasks.Task`1.InnerInvoke()
    at System.Threading.Tasks.Task.Execute()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Microsoft.PowerBI.Client.Windows.FloatingDialog.ImportFromExcelDialog.<<StartImport>b__6>d__7.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAsyncExceptions>d__0.MoveNext()

    Invocation Stack Trace:
    at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
    at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace)
    at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception)
    at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
    at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)
    at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAsyncExceptions>d__0.MoveNext()
    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.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
    at System.Threading.Tasks.AwaitTaskContinuation.RunCallback(ContextCallback callback, Object state, Task& currentTask)
    at System.Threading.Tasks.Task.FinishContinuations()
    at System.Threading.Tasks.Task.Finish(Boolean bUserDelegateExecuted)
    at System.Threading.Tasks.Task`1.TrySetException(Object exceptionObject)
    at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.SetException(Exception exception)
    at Microsoft.PowerBI.Client.Windows.FloatingDialog.ImportFromExcelDialog.<<StartImport>b__6>d__7.MoveNext()
    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.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
    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.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)
    at Microsoft.PowerBI.Client.Windows.MainWindow.ImportFromExcelFile(String filePath)
    at Microsoft.PowerBI.Client.Windows.MainWindow.<<ImportFromExcel>b__2c>d__2d.MoveNext()
    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.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
    at System.Threading.Tasks.AwaitTaskContinuation.RunCallback(ContextCallback callback, Object state, Task& currentTask)
    at System.Threading.Tasks.Task.FinishContinuations()
    at System.Threading.Tasks.Task`1.TrySetResult(TResult result)
    at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.SetResult(TResult result)
    at Microsoft.PowerBI.Client.Windows.MainWindow.<IsSaveChangesPromptNeeded>d__71.MoveNext()
    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.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
    at System.Threading.Tasks.AwaitTaskContinuation.RunCallback(ContextCallback callback, Object state, Task& currentTask)
    at System.Threading.Tasks.Task.FinishContinuations()
    at System.Threading.Tasks.Task`1.TrySetResult(TResult result)
    at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.SetResult(TResult result)
    at Microsoft.PowerBI.Client.Windows.CefSharpFramework.CefWebBrowser.<InvokeScriptAsync>d__1`1.MoveNext()
    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.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
    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.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)
    at Microsoft.PowerBI.Client.Program.<>c__DisplayClassb.<Main>b__0()
    at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
    at Microsoft.PowerBI.Client.Program.Main(String[] args)


    User ID:
    3082784f-157e-46e8-829a-c35cf7416659

    Session ID:
    e24bef5a-6258-4da0-b3e8-655f0f6bfa63

    Telemetry Enabled:
    True

    Model Default Mode:
    Import

    Snapshot Trace Logs:
    C:\Users\Tim\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1596447102.zip

    Disabled Preview Features:
    SapBusinessWarehouse
    PBI_allowDrillGrouping

    Disabled DirectQuery Options:
    DirectQuery_Unrestricted

    Formulas:


    section Section1;