Adobe analytics connector not loading data. Has errors when selecting field

[dpmsvendor]

Trying to get data using Adobe Analytics connector on desktop, but getting errors when selecting a field

Feedback Type:
Frown (Error)

Timestamp:
2024-01-26T22:12:36.9219070Z

Local Time:
2024-01-26T14:12:36.9219070-08:00

Session ID:
fd733730-1846-4770-9e6d-ace2ff276f8a

Release:
December 2023

Product Version:
2.124.1826.0 (23.12) (x64)

Stack Trace:
System.IO.FileNotFoundException
at Microsoft.Mashup.Web.Diagnostics.ITracingServiceExtensions.GetDetails(Exception ex, String additionalDetails)
at Microsoft.Mashup.Web.Diagnostics.ITracingServiceExtensions.TraceException(ITracingService tracingService, TracingLevel tracingLevel, Exception ex, String additionalDetails, String callerFunctionName, String callerFilePath) in D:\dbs\el\appq\src\Product\Diagnostics\ITracingServiceExtensions.cs:line 51
at Microsoft.Mashup.Client.Desktop.UI.Internal.LoggingInteropRequestExceptionManager.HandleException(Exception exception) in D:\dbs\el\appq\src\Product\Client\Desktop\UI\Internal\LoggingInteropRequestExceptionManager.cs:line 37
at Microsoft.Mashup.WebViews.App.Common.ScriptInterop.InteropRequestHandler.HandleServiceMethodInvocationException(Exception e, String requestId)
at Microsoft.Mashup.WebViews.App.Common.ScriptInterop.InteropRequestHandler.<InvokeServiceMethodAndResolveRequest>d__8.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.Mashup.WebViews.App.Common.ScriptInterop.InteropRequestHandler.<HandleRequest>d__5.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.Mashup.WebViews.App.Common.IWebViewExceptionHandlerExtensions.<TryInvokeAsync>d__1.MoveNext()

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.124.1826.0","ModuleName":"Microsoft.Mashup.Web.Diagnostics.dll","Component":"Microsoft.Mashup.Web.Diagnostics.ITracingServiceExtensions","Error":"System.IO.FileNotFoundException","MethodDef":"GetDetails","ErrorOffset":"-1","ErrorCode":""}

OS Version:
Microsoft Windows NT 10.0.22631.0 (x64 en-US)

CLR Version:
4.8 or later [Release Number = 533320]

Peak Virtual Memory:
70.1 GB

Private Memory:
541 MB

Peak Working Set:
983 MB

IE Version:
11.1.22621.0

User ID:
fc243538-9d4c-4a8f-9427-e55af80b11e2

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

Model Default Mode:
Empty

Model Version:
PowerBI_V1

Enabled Preview Features:
PBI_sparklines
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_backstageUI
PBI_setLabelOnExportPdf
PBI_dynamicFormatString
PBI_oneDriveSave
PBI_oneDriveShare
PBI_newCard
PBI_buttonSlicerAuthoring
PBI_useModernMashupEditor

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_angularRls
PBI_onObject
PBI_useModernPublishDialogs
PBI_gitIntegration
PBI_modelExplorer
PBI_daxQueryView
PBI_aiNarrativesVisual
PBI_qnaImproveLsdlCopilot

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
MSIT

DPI Scale:
100%

Supported Services:
Power BI

[Anonymous]

Hi @dpmsvendor ,

You may try it in a separate browser, navigate to the link defined with the client_id used by the Power BI Desktop application that you need to authorize with Adobe. Login with your Adobe ID. The Authorization page will appear. Authorize access and then close the browser window after it progresses to a blank screen at “https://oauth.powerbi.com”. Then go back to Power BI Desktop and you should be able to successfully log in with your newly authorized Adobe ID.

Or In Power BI, under Edit Queries on the ribbon, select Data Source Settings. Delete all cached credentials for Adobe Analytics from both the Data sources in the current file and Global permissions lists, and then try to authenticate again.

If you’re using an older version of Power BI Desktop, consider updating to the latest version.

Best regards.
Community Support Team_Caitlyn

[dpmsvendor]

All cached credentials were deleted on desktop. I tried to select a field, but got this error. Thanks!

Feedback Type:
Frown (Error)

Error Message:
Could not load file or assembly 'AsyncFriendlyStackTrace, Version=1.5.0.0, Culture=neutral, PublicKeyToken=f5fdf019656607c4' or one of its dependencies. The system cannot find the file specified.

Stack Trace:
System.IO.FileNotFoundException
at Microsoft.Mashup.Web.Diagnostics.ITracingServiceExtensions.GetDetails(Exception ex, String additionalDetails)
at Microsoft.Mashup.Web.Diagnostics.ITracingServiceExtensions.TraceException(ITracingService tracingService, TracingLevel tracingLevel, Exception ex, String additionalDetails, String callerFunctionName, String callerFilePath) in D:\dbs\el\appq\src\Product\Diagnostics\ITracingServiceExtensions.cs:line 51
at Microsoft.Mashup.Client.Desktop.UI.Internal.LoggingInteropRequestExceptionManager.HandleException(Exception exception) in D:\dbs\el\appq\src\Product\Client\Desktop\UI\Internal\LoggingInteropRequestExceptionManager.cs:line 37
at Microsoft.Mashup.WebViews.App.Common.ScriptInterop.InteropRequestHandler.HandleServiceMethodInvocationException(Exception e, String requestId)
at Microsoft.Mashup.WebViews.App.Common.ScriptInterop.InteropRequestHandler.<InvokeServiceMethodAndResolveRequest>d__8.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.Mashup.WebViews.App.Common.ScriptInterop.InteropRequestHandler.<HandleRequest>d__5.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.Mashup.WebViews.App.Common.IWebViewExceptionHandlerExtensions.<TryInvokeAsync>d__1.MoveNext()

Stack Trace Message:
Could not load file or assembly 'AsyncFriendlyStackTrace, Version=1.5.0.0, Culture=neutral, PublicKeyToken=f5fdf019656607c4' or one of its dependencies. The system cannot find the file specified.

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__DisplayClass14_0.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.PowerBI.Client.Windows.Utilities.PowerBIFormUnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.Mashup.WebViews.App.Common.IWebViewExceptionHandlerExtensions.<TryInvokeAsync>d__1.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.Mashup.WebViews.App.Common.IWebViewExceptionHandlerExtensions.TryInvokeAsync(IWebViewExceptionHandler exceptionHandler, Func`1 actionAsync)
at Microsoft.Mashup.WebViews.App.Common.WebViewWindowBase.<InvokeRetainedAsync>d__25.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.Mashup.WebViews.App.Common.WebViewWindowBase.InvokeRetainedAsync(Func`1 asyncFunc)
at Microsoft.Mashup.WebViews.App.Common.WebViewWindowBase.<OnWebViewScriptNotify>d__27.MoveNext()
at System.Runtime.CompilerServices.AsyncVoidMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.Mashup.WebViews.App.Common.WebViewWindowBase.OnWebViewScriptNotify(Object sender, WebViewScriptNotifyEventArgs e)
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.Desktop.UI.Internal.PowerQueryWebView.ExecuteFlowAsync(IViewHandle owner, Boolean showModal, IExceptionHandler exceptionHandler, IInteropRequestExceptionManager interopRequestExceptionManager, IInteropServiceLocator interopServiceLocator, FlowSettings flowSettings, Task flowInitializationTask) in D:\dbs\el\appq\src\Product\Client\Desktop\UI\Internal\PowerQueryWebView.cs:line 92
at Microsoft.Mashup.Client.Desktop.UI.Internal.Flows.UIFlow`4.<ExecuteAsync>d__36.MoveNext() in D:\dbs\el\appq\src\Product\Client\Desktop\UI\Internal\Flows\UIFlow.cs:line 196
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.Mashup.Client.Desktop.UI.Internal.Flows.UIFlow`4.ExecuteAsync(IViewHandle owner, Boolean showModal, FlowSettings flowSettings, IUIFlowState`4 uiFlowState, Task initializationTask, WindowSizes windowSizes)
at Microsoft.Mashup.Client.Desktop.UI.Internal.Flows.MashupUIFlow`3.ExecuteAsync(IViewHandle owner, Boolean showModal, TMashupFlowSettings flowSettings, EditingSessionMashup editingSessionMashup, DialogSettings dialogSettings) in D:\dbs\el\appq\src\Product\Client\Desktop\UI\Internal\Flows\MashupUIFlow.cs:line 77
at Microsoft.Mashup.Client.Desktop.UI.Internal.Flows.AddQueriesUIFlow.ExecuteAsync(IViewHandle owner, Boolean showModal, EditingSessionMashup editingSessionMashup) in D:\dbs\el\appq\src\Product\Client\Desktop\UI\Internal\Flows\AddQueriesUIFlow.cs:line 101
at Microsoft.Mashup.Client.Desktop.UI.Internal.PowerQueryUI.AddQueriesAsync(IViewHandle owner, Boolean showModal, UIFlowParamsFactory uiFlowParamsFactory, EditingSessionMashup editingSessionMashup, AddQueriesSettings addQueriesSettings) in D:\dbs\el\appq\src\Product\Client\Desktop\UI\Internal\PowerQueryUI.cs:line 46
at Microsoft.PowerBI.Client.Windows.QueryEditor.PowerQueryUIService.AddQueries(Queries queries, String sourceId, PBIConnectivityModeSettings pbiConnectivityModeSettings, IPowerQueryUICallbacks pqCallbacks)
at Microsoft.PowerBI.Client.Windows.QueryEditor.MashupEditorService.GetData(PowerBIDataImporter _dataImporter, String sourceId, Nullable`1 _targetQueryGroupId, IDataSourceTemplateProvider _dataSourceTemplateProvider, IWindowHandle _ownerWindow)
at Microsoft.PowerBI.Client.Windows.Commands.ApplicationCommands.DataImportCommands.<Connect>d__48.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.Commands.ApplicationCommands.DataImportCommands.Connect(IPowerBIWindowService windowService, IExceptionHandler exceptionHandler, ConnectParameters parameters)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAwaitableAsyncExceptions(IExceptionHandler exceptionHandler, Func`1 asyncFunc)
at Microsoft.PowerBI.Client.Windows.Commands.CompositeCommand`1.Execute(ICommand command, Object parameter)
at Microsoft.Practices.Prism.Commands.CompositeCommand.Execute(Object parameter)
at Microsoft.PowerBI.Client.Windows.Commands.CompositeCommand`1.Execute(T parameter)
at Microsoft.PowerBI.Client.Windows.CommandStoreHostService.<ExecuteCore>d__14.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.CommandStoreHostService.ExecuteCore(String commandId, String parameterJson, Int64 promiseHandle)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAwaitableAsyncExceptions(IExceptionHandler exceptionHandler, Func`1 asyncFunc)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAsyncExceptions>d__0.MoveNext()
at System.Runtime.CompilerServices.AsyncVoidMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAsyncExceptions(IExceptionHandler exceptionHandler, Func`1 asyncFunc)
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__DisplayClass6_0.<RunApplication>b__0()
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.RunApplication(String[] args)
at Microsoft.PowerBI.Client.Program.Main(String[] args)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.124.1826.0","ModuleName":"Microsoft.Mashup.Web.Diagnostics.dll","Component":"Microsoft.Mashup.Web.Diagnostics.ITracingServiceExtensions","Error":"System.IO.FileNotFoundException","MethodDef":"GetDetails","ErrorOffset":"-1","ErrorCode":""}

Snapshot Trace Logs:
C:\Users\v-\Microsoft\Power BI Desktop Store App\FrownSnapShotd3ef35f4-ef6f-415a-9631-5d943d9b9cb0.zip

Model Default Mode:
Empty

Model Version:
PowerBI_V1

Performance Trace Logs:
C:\Users\v-\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip

Enabled Preview Features:
PBI_sparklines
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_backstageUI
PBI_setLabelOnExportPdf
PBI_dynamicFormatString
PBI_oneDriveSave
PBI_oneDriveShare
PBI_newCard
PBI_buttonSlicerAuthoring
PBI_useModernMashupEditor

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_angularRls
PBI_onObject
PBI_useModernPublishDialogs
PBI_gitIntegration
PBI_modelExplorer
PBI_daxQueryView
PBI_aiNarrativesVisual
PBI_qnaImproveLsdlCopilot

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
MSIT

PowerBIUserFeedbackServices_IsReported:
True

Formulas:

section Section1;

[QueryWhiz]

Hi @dpmsvendor were you able to find a solution? I used the Adobe native connector but I had some issues with my data, so I finally ended up using a 3rd party tool. Maybe that could be useful as a workaround. I've tried windsor.ai , supemetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder,  to make the connection first search for the Adobe connector in the data sources list:

Then, you should enter your Adobe credentials to make the connection. After that, you'll see a preview of your data where you can select the fields you want to see in PBI. 

Finally, you just have to choose PBI as destination and copy and paste the url that will appear there in PBI desktop --> Get Data --Web > --> Paste the link

[dpmsvendor]

Thanks @QueryWhiz  for your suggestion. I will check out those solutions you shared.

For now, the workaround is to turn off New Power Query Experience within Options>Preview features