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
- AnonymousNot 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 - dpmsvendorMicrosoft 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.zipModel Default Mode:
EmptyModel Version:
PowerBI_V1Performance Trace Logs:
C:\Users\v-\Microsoft\Power BI Desktop Store App\PerformanceTraces.zipEnabled 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_useModernMashupEditorDisabled 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_qnaImproveLsdlCopilotDisabled DirectQuery Options:
TreatHanaAsRelationalSourceCloud:
MSITPowerBIUserFeedbackServices_IsReported:
TrueFormulas:
section Section1; - QueryWhizPost Patron
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
- dpmsvendorMicrosoft 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