"Invoke Attempt Failed"

[thnemeth]

I can't even find any google search results for that phrase.  It doesn't exist.

I was putzing on and off for about a week on a MSPBI Dashboard that I left open.  I don't remember everything I did because it was such a long amount of putzing.  But suddenly this morning I started getting an error seen here:

I don't think I have any custom functions that are getting invoked, and here is a picture of my query list.  The last one is cut off but it is the last one:

The two parameters are simple dates

Lastly, the error details from the first picture are HUGE, and exceeds the character limit so a portion is below and I put the rest on google drive (Not sure if the link will be valid).  Any idea what's going on?

Feedback Type:
Frown (Error)

Error Message:
Invoke Attempt Failed

Stack Trace:
   at Microsoft.PowerBI.Client.Windows.ScriptAsyncInvokeAttempt`1.get_Result()
   at Microsoft.PowerBI.Client.Windows.Views.MinervaInterop.ModelViewClientHost.<>c__DisplayClass13_0.<<GetDocumentContent>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.PowerBI.Client.Windows.Views.WebDiagramState.<GetSerializedState>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.PowerBI.Client.Windows.Views.MinervaInterop.ModelViewClientHost.<GetDocumentContent>d__13.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.PowerBI.Client.Windows.Report.<CommitUIState>d__65.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.PowerBI.Client.Windows.Services.AutoRecoveryManager.<<PerformAutoSave>b__82_1>d.MoveNext()

Stack Trace Message:
Invoke Attempt Failed

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.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass0_1.<SendAndMarshalExceptions>b__0(Object null)
   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.87.1061.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.ScriptAsyncInvokeAttempt`1","Error":"System.InvalidOperationException","MethodDef":"get_Result","ErrorOffset":"23"}

Snapshot Trace Logs:
C:\Users\thnemeth\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot35ccc888-5dcd-45d9-8225-bd152d0a105d.zip

Model Default Mode:
Import

Model Version:
PowerBI_V3

Is Report V3 Models Enabled:
True

Performance Trace Logs:
C:\Users\thnemeth\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:
PBI_NewWebTableInference
PBI_v3ModelsPreview

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_JsonTableInference
PBI_ImportTextByExample
PBI_ExcelTableInference
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_narrativeTextBox
PBI_dynamicParameters
PBI_anomalyDetection
PBI_newFieldList

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

PowerBIUserFeedbackServices_IsReported:
True

Formulas:


section Section1;
[etc the rest is truncated]

[thnemeth · Accepted solution]

So this is a very unfortunate reply for me to write:  It turns out (?) that the MSPBI file basically got corrupted while I was working on it for 7 days.  Later in the day I tried to save it, and I kept getting an error saying it was unable to save it.  So I copied all of the code behind my queries into different notepad files, closed the file, rebooted, opened it again, and copied all of my queries from Notepad back into it.

The error is gone.

So maybe the reason why I couldn't find information on "Invoke Attempt Failed" was because it's a nonsense error fixed by discarding all your work and going back to the last successful save 😞

I do appreciate everybody's thoughts/input on this, I'm sorry this wasn't more interesting (?)

[mahoneypat]

You could narrow it down by disabling load on each query (or in groups to check faster) to see when it goes away.  Then you could troubleshoot and maybe rebuild that query.  Make sure you don't have any measures or DAX columns on any tables you disable load on so you don't lose them.

Regards,

Pat

[lbendlin]

Have you tried pushing past that error (basically ignoring it)? Is it reproducible? When does it appear?

[thnemeth]

Hey lbendlin; I knew I forgot some other information.

So from what I can tell I can push past it and ignore it entirely.  It doesn't appear to mean anything.  But I would really prefer to be able to do something about it to stop it from appearing since I'm going to be sharing this dashboard with a large quantity of people outside of my department and I don't want them getting confused.

It is reproduceable:  I've seen it about 10-15 times today.  When it pops up, it prevents me from clicking on/using any other part of Power BI until I close that error window.  Which I find interesting, but maybe that's normal error message behavior (I haven't gotten lots of errors in the past, haha)

When does it appear?  I'm not sure.  It appears to be something background related.  Because if will usually appear if I click 'Refresh All' but sometimes I'll just be in the query editor, and I'll step away for 20 minutes, come back, and the error has popped-under the Query Editor.

[lbendlin]

Did you enable automatic page refresh anywhere?