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 elimination by stripping out queries, calculated columns and measures but kept getting this error.  

 

Would love any ideas or guidance as I'm ready to transition to Desktop as the primary Power BI tool but do not want to recreate everything from scratch.

 

Best regards,

Tim

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    timmcn What version of Excel are you running?

    • timmcn's avatar
      timmcn
      Regular Visitor
      10 years ago

      Hi Eno,

       

      2016 ProPlus 64 bit

       

      Not sure they could be causing the problem, but I also have installed the following add-ins:

      1. PowerPivot utilities

      2. Dax Studio Excel AddiIn

      3. OLAP PivotTable Extensions

       

      Best regards,

      Tim

  • 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;