dpmsvendor's avatar
dpmsvendor
Microsoft Employee
2 years ago
Status:
Investigating

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

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

 

 

 

 

4 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
    dpmsvendor
    Microsoft Employee

    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;

  • 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's avatar
    dpmsvendor
    Microsoft Employee

    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