I was trying to use the Outlier Detection visual available here: https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104381449?tab=overview My data captures sharepoint form page load times in milliseconds to monitor performance, and look something like this: ID Title BrowserName FormName URL_loaded Created AuthorId LoadTimeMS 1 globalNewFormInitiatedHandler Chrome NewForm .../NewForm.aspx 1/11/2021 26 11789 2 globalEditFormInitiatedHandler MSIE EditForm .../EditForm.aspx?ID=2201 1/11/2021 26 10188 3 globalEditFormInitiatedHandler Chrome EditForm .../EditForm.aspx?ID=312 1/11/2021 26 10210 4 globalEditFormInitiatedHandler MSIE EditForm .../EditForm.aspx?ID=2591 1/11/2021 26 10446 Error details: Feedback Type:
Frown (Error)
Timestamp:
2021-01-12T15:45:37.0243441Z
Local Time:
2021-01-12T07:45:37.0243441-08:00
Session ID:
c80352db-37cc-45dc-8b43-deb86ebf9d2b
Release:
January 2020
Product Version:
2.76.5678.1521 (19.12) (x64)
Error Message:
R script error.
Loading required package: XML
Loading required package: htmlwidgets
Loading required package: ggplot2
Loading required package: plotly
Loading required package: DMwR
Loading required package: scales
Loading required package: caTools
Error: could not find function "ggplot"
Execution halted
Stack Trace:
Microsoft.PowerBI.ExploreServiceCommon.ScriptHandlerException: R script error.
Loading required package: XML
Loading required package: htmlwidgets
Loading required package: ggplot2
Loading required package: plotly
Loading required package: DMwR
Loading required package: scales
Loading required package: caTools
Error: could not find function "ggplot"
Execution halted
---> Microsoft.PowerBI.Scripting.R.Exceptions.RScriptRuntimeException: R script error.
Loading required package: XML
Loading required package: htmlwidgets
Loading required package: ggplot2
Loading required package: plotly
Loading required package: DMwR
Loading required package: scales
Loading required package: caTools
Error: could not find function "ggplot"
Execution halted
at Microsoft.PowerBI.Scripting.R.RScriptWrapper.RunScript(String originalScript, Int32 timeoutMs)
at Microsoft.PowerBI.Client.Windows.R.RScriptHandler.GenerateVisual(ScriptHandlerOptions options)
--- End of inner exception stack trace ---
at Microsoft.PowerBI.Client.Windows.R.RScriptHandler.GenerateVisual(ScriptHandlerOptions options)
at Microsoft.PowerBI.ExploreServiceCommon.ScriptVisualCommandFlow.RunInternal(Stream dataShapeResultStream, QueryBindingDescriptor& bindingDescriptor)
at Microsoft.PowerBI.ExploreServiceCommon.ScriptVisualCommandFlow.Run(Stream dataShapeResultStream, QueryBindingDescriptor& bindingDescriptor)
at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.TransformDataShapeResult(QueryCommand transformCommand, SemanticQueryDataShapeCommand command, Stream dataShapeResultStream, QueryBindingDescriptor& bindingDescriptor)
at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.ExecuteDataQuery(IQueryResultDataWriter queryResultDataWriter, EngineDataModel engineDataModel, DataQuery query, Int32 queryId, ServiceErrorStatusCode& serviceErrorStatusCode, CancellationToken cancelToken)
at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.ProcessAndWriteSemanticQueryCommands(IQueryResultsWriter queryResultsWriter, IList`1 queries, HashSet`1 pendingQueriesToCancel, EngineDataModel engineDataModel)
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.ErrorHostService.GetErrorDetails(ShowErrorDialogArgs args)
at Microsoft.PowerBI.Client.Windows.ErrorHostService.<>c__DisplayClass2_0.<<ShowErrorDialog>b__0>d.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.ErrorHostService.<>c__DisplayClass2_0.<ShowErrorDialog>b__0()
at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass1_0`1.<SendAndMarshalExceptions>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.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass2_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)
OS Version:
Microsoft Windows NT 10.0.17763.0 (x64 en-US)
CLR Version:
4.7 or later [Release Number = 461814]
Peak Virtual Memory:
38.3 GB
Private Memory:
417 MB
Peak Working Set:
569 MB
IE Version:
11.1577.17763.0
User ID:
4262ad2e-75c5-40bf-97df-99d13b6f4e75
Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.
Telemetry Enabled:
False
Snapshot Trace Logs:
C:\Users\U771301\AppData\Local\Microsoft\Power BI Desktop SSRS\FrownSnapShot590706485.zip
Model Default Mode:
Import
Performance Trace Logs:
C:\Users\U771301\AppData\Local\Microsoft\Power BI Desktop SSRS\PerformanceTraces.zip
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_NewWebTableInference
PBI_showIncrementalRefreshPolicy
PBI_qnaLiveConnect
PQ_AIInsightsFunctionBrowser
PBI_realTimeRefresh
PBI_QueryDiagnostics
PBI_showMinervaRibbon
PBI_showMinervaViewNavigator
PBI_decompositionTree
PBI_themeDialog
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
100%
Supported Services:
Power BI Report Server, Power BI
Formulas:
section Section1;
shared PerformanceTracking = let
Source = SharePoint.Tables("http://solutions.entshpt.companyname.net/sites/ERIA/RPAPipelineManagement", [ApiVersion = 15]),
#"22be4276-7e29-47c1-b086-a8135681b45e" = Source{[Id="22be4276-7e29-47c1-b086-a8135681b45e"]}[Items],
#"Renamed Columns" = Table.RenameColumns(#"22be4276-7e29-47c1-b086-a8135681b45e",{{"ID", "ID.1"}})
in
#"Renamed Columns";
shared #"User Information List" = let
Source = SharePoint.Tables("http://solutions.entshpt.companyname.net/sites/ERIA", [ApiVersion = 15]),
#"4ed66c39-32d3-4055-afbd-5acc1cdecb1d" = Source{[Id="4ed66c39-32d3-4055-afbd-5acc1cdecb1d"]}[Items],
#"Renamed Columns" = Table.RenameColumns(#"4ed66c39-32d3-4055-afbd-5acc1cdecb1d",{{"ID", "ID.1"}})
in
#"Renamed Columns";
shared #"User Information List (2)" = let
Source = SharePoint.Tables("http://solutions.entshpt.companyname.net/sites/ERIA", [ApiVersion = 15]),
#"4ed66c39-32d3-4055-afbd-5acc1cdecb1d" = Source{[Id="4ed66c39-32d3-4055-afbd-5acc1cdecb1d"]}[Items],
#"Renamed Columns" = Table.RenameColumns(#"4ed66c39-32d3-4055-afbd-5acc1cdecb1d",{{"ID", "ID.1"}})
in
#"Renamed Columns";
... View more