dumbbell chart by maq software not working

Daylea · ‎06-22-2023

Hello

No Visual display with the below error message. Appreciate your help. Thank you!

Feedback Type:
Frown (Error)

Timestamp:
2023-06-22T08:34:06.6607832Z

Local Time:
2023-06-22T16:34:06.6607832+08:00

Session ID:
0dbeb5f9-0598-44b2-8cb9-77659c0686a3

Release:
April 2022

Product Version:
2.104.702.0 (22.04) (x64)

Error Message:
R script error.
Loading required package: XML
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'XML'
2: In libraryRequireInstall("XML") :
*** The package: 'XML' was not installed ***
Loading required package: htmlwidgets
Warning message:
package 'htmlwidgets' was built under R version 4.2.3
Loading required package: ggplot2
Warning message:
package 'ggplot2' was built under R version 4.2.3
Loading required package: plotly
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'plotly'
2: In libraryRequireInstall("plotly") :
*** The package: 'plotly' was not installed ***
Loading required package: ggplotly
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'ggplotly'
2: In libraryRequireInstall("ggplotly") :
*** The package: 'ggplotly' was not installed ***
Loading required package: gapminder
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'gapminder'
2: In libraryRequireInstall("gapminder") :
*** The package: 'gapminder' was not installed ***
Loading required package: gsubfn
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'gsubfn'
2: In libraryRequireInstall("gsubfn") :
*** The package: 'gsubfn' was not installed ***
Loading required package: magrittr
Warning message:
package 'magrittr' was built under R version 4.2.3
Loading required package: XML
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'XML'
2: In libraryRequireInstall("XML") :
*** The package: 'XML' was not installed ***
Error in layout(., title = "", xaxis = xlayout, yaxis = ylayout) :
unused arguments (title = "", xaxis = xlayout, yaxis = ylayout)
Calls: tryCatch -> tryCatchList -> tryCatchOne -> <Anonymous> -> %>%
Execution halted

Stack Trace:
Microsoft.PowerBI.ExploreServiceCommon.ScriptHandlerException: R script error.
Loading required package: XML
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'XML'
2: In libraryRequireInstall("XML") :
*** The package: 'XML' was not installed ***
Loading required package: htmlwidgets
Warning message:
package 'htmlwidgets' was built under R version 4.2.3
Loading required package: ggplot2
Warning message:
package 'ggplot2' was built under R version 4.2.3
Loading required package: plotly
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'plotly'
2: In libraryRequireInstall("plotly") :
*** The package: 'plotly' was not installed ***
Loading required package: ggplotly
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'ggplotly'
2: In libraryRequireInstall("ggplotly") :
*** The package: 'ggplotly' was not installed ***
Loading required package: gapminder
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'gapminder'
2: In libraryRequireInstall("gapminder") :
*** The package: 'gapminder' was not installed ***
Loading required package: gsubfn
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'gsubfn'
2: In libraryRequireInstall("gsubfn") :
*** The package: 'gsubfn' was not installed ***
Loading required package: magrittr
Warning message:
package 'magrittr' was built under R version 4.2.3
Loading required package: XML
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'XML'
2: In libraryRequireInstall("XML") :
*** The package: 'XML' was not installed ***
Error in layout(., title = "", xaxis = xlayout, yaxis = ylayout) :
unused arguments (title = "", xaxis = xlayout, yaxis = ylayout)
Calls: tryCatch -> tryCatchList -> tryCatchOne -> <Anonymous> -> %>%
Execution halted
---> Microsoft.PowerBI.Scripting.R.Exceptions.RScriptRuntimeException: R script error.
Loading required package: XML
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'XML'
2: In libraryRequireInstall("XML") :
*** The package: 'XML' was not installed ***
Loading required package: htmlwidgets
Warning message:
package 'htmlwidgets' was built under R version 4.2.3
Loading required package: ggplot2
Warning message:
package 'ggplot2' was built under R version 4.2.3
Loading required package: plotly
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'plotly'
2: In libraryRequireInstall("plotly") :
*** The package: 'plotly' was not installed ***
Loading required package: ggplotly
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'ggplotly'
2: In libraryRequireInstall("ggplotly") :
*** The package: 'ggplotly' was not installed ***
Loading required package: gapminder
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'gapminder'
2: In libraryRequireInstall("gapminder") :
*** The package: 'gapminder' was not installed ***
Loading required package: gsubfn
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'gsubfn'
2: In libraryRequireInstall("gsubfn") :
*** The package: 'gsubfn' was not installed ***
Loading required package: magrittr
Warning message:
package 'magrittr' was built under R version 4.2.3
Loading required package: XML
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'XML'
2: In libraryRequireInstall("XML") :
*** The package: 'XML' was not installed ***
Error in layout(., title = "", xaxis = xlayout, yaxis = ylayout) :
unused arguments (title = "", xaxis = xlayout, yaxis = ylayout)
Calls: tryCatch -> tryCatchList -> tryCatchOne -> <Anonymous> -> %>%
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.ExploreHost.SemanticQuery.ScriptVisualCommandFlow.RunInternal(Stream dataShapeResultStream, QueryBindingDescriptor& bindingDescriptor)
at Microsoft.PowerBI.ExploreHost.SemanticQuery.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__DisplayClass5_0.<ShowErrorDialogCore>b__0()
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.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at System.Windows.Forms.WindowsFormsSynchronizationContext.Send(SendOrPostCallback d, Object state)
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.AllowModalDialogs(Action action)
at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<>c__DisplayClass14_0.<ExecuteOnUIThreadAndHandlePromise>b__0()
at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.ExecuteOnUIThreadAndHandlePromise[T](Func`1 func, IPromiseStore promiseStore, Int64 promiseHandle)
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.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.PowerBI.Client.Windows.WebView2.WebView2Interop.InvokeCs(InteropCall call)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at System.EventHandler`1.Invoke(Object sender, TEventArgs 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.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_1.<Main>b__2()
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.22621.0 (x64 en-US)

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

Peak Virtual Memory:
72 GB

Private Memory:
1.42 GB

Peak Working Set:
1.8 GB

IE Version:
11.1.22621.0

User ID:
0752850b-169f-4e18-ac32-c947937dd088

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

Telemetry Enabled:
True

Snapshot Trace Logs:
C:\Users\poonc\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot4d611c1c-e953-4dc6-90e0-4e160c411152.zip

Model Default Mode:
Import

Model Version:
PowerBI_V3

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

Enabled Preview Features:
PBI_enableWebView2
PBI_mobileAuthoringFormattingUI
PBI_useModernFormatPane
PBI_sparklines

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_compositeModelsOverAS
PBI_enhancedTooltips
PQ_WebView2Connector
PBI_scorecardVisual
PBI_lineChartError

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
150%

Supported Services:
Power BI

Formulas:

section Section1;

shared Analysis = let
Source = Excel.Workbook(File.Contents("C:\Users\poonc\OneDrive\Desktop\Master Copy.xlsx"), null, true),
Analysis_Sheet = Source{[Item="Analysis",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Analysis_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"JobID", type text}, {"Source", type text}, {"Title", type text}, {"Type of Analyst", type text}, {"Company Name", type text}, {"Job Type", type text}, {"SC or Manager", type text}, {"JD", type text}, {"Hardskill", type text}, {"Qualification", type text}, {"Year of Experience", type any}, {"Industry Grouping", type text}, {"Industry", type text}, {"Company Size Range", type any}, {"Recruiter?", type text}, {"Salary Included?", type text}})
in
#"Changed Type";

shared Salary = let
Source = Excel.Workbook(File.Contents("C:\Users\poonc\OneDrive\Desktop\Master Copy.xlsx"), null, true),
Salary_Sheet = Source{[Item="Salary",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Salary_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Job ID", type text}, {"Range", type text}, {"Salary", type number}})
in
#"Changed Type";

Anonymous · ‎06-26-2023

Hi @Daylea ,

We see that you are using the April '22 version. PowerBI has been updated to the June '2023 version. For your better experience, would you mind updating the version and seeing if the problem still exists?

Download Microsoft Power BI Desktop from Official Microsoft Download Center

Best regards.
Community Support Team_Caitlyn

Daylea · ‎06-26-2023

Hi @Anonymous ,

Thank you for getting back. I did update to the newest version but same error message:

Feedback Type:
Frown (Error)

Error Message:
R script error.
Loading required package: XML
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'XML'
2: In libraryRequireInstall("XML") :
*** The package: 'XML' was not installed ***
Loading required package: htmlwidgets
Warning message:
package 'htmlwidgets' was built under R version 4.2.3
Loading required package: ggplot2
Warning message:
package 'ggplot2' was built under R version 4.2.3
Loading required package: plotly
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'plotly'
2: In libraryRequireInstall("plotly") :
*** The package: 'plotly' was not installed ***
Loading required package: ggplotly
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'ggplotly'
2: In libraryRequireInstall("ggplotly") :
*** The package: 'ggplotly' was not installed ***
Loading required package: gapminder
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'gapminder'
2: In libraryRequireInstall("gapminder") :
*** The package: 'gapminder' was not installed ***
Loading required package: gsubfn
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'gsubfn'
2: In libraryRequireInstall("gsubfn") :
*** The package: 'gsubfn' was not installed ***
Loading required package: magrittr
Warning message:
package 'magrittr' was built under R version 4.2.3
Loading required package: XML
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'XML'
2: In libraryRequireInstall("XML") :
*** The package: 'XML' was not installed ***
Error in layout(., title = "", xaxis = xlayout, yaxis = ylayout) :
unused arguments (title = "", xaxis = xlayout, yaxis = ylayout)
Calls: tryCatch -> tryCatchList -> tryCatchOne -> <Anonymous> -> %>%
Execution halted

Stack Trace:
Javascript&colon; Error
Microsoft.PowerBI.ExploreServiceCommon.ScriptHandlerException: R script error.
Loading required package: XML
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'XML'
2: In libraryRequireInstall("XML") :
*** The package: 'XML' was not installed ***
Loading required package: htmlwidgets
Warning message:
package 'htmlwidgets' was built under R version 4.2.3
Loading required package: ggplot2
Warning message:
package 'ggplot2' was built under R version 4.2.3
Loading required package: plotly
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'plotly'
2: In libraryRequireInstall("plotly") :
*** The package: 'plotly' was not installed ***
Loading required package: ggplotly
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'ggplotly'
2: In libraryRequireInstall("ggplotly") :
*** The package: 'ggplotly' was not installed ***
Loading required package: gapminder
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'gapminder'
2: In libraryRequireInstall("gapminder") :
*** The package: 'gapminder' was not installed ***
Loading required package: gsubfn
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'gsubfn'
2: In libraryRequireInstall("gsubfn") :
*** The package: 'gsubfn' was not installed ***
Loading required package: magrittr
Warning message:
package 'magrittr' was built under R version 4.2.3
Loading required package: XML
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'XML'
2: In libraryRequireInstall("XML") :
*** The package: 'XML' was not installed ***
Error in layout(., title = "", xaxis = xlayout, yaxis = ylayout) :
unused arguments (title = "", xaxis = xlayout, yaxis = ylayout)
Calls: tryCatch -> tryCatchList -> tryCatchOne -> <Anonymous> -> %>%
Execution halted
---> Microsoft.PowerBI.Scripting.R.Exceptions.RScriptRuntimeException: R script error.
Loading required package: XML
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'XML'
2: In libraryRequireInstall("XML") :
*** The package: 'XML' was not installed ***
Loading required package: htmlwidgets
Warning message:
package 'htmlwidgets' was built under R version 4.2.3
Loading required package: ggplot2
Warning message:
package 'ggplot2' was built under R version 4.2.3
Loading required package: plotly
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'plotly'
2: In libraryRequireInstall("plotly") :
*** The package: 'plotly' was not installed ***
Loading required package: ggplotly
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'ggplotly'
2: In libraryRequireInstall("ggplotly") :
*** The package: 'ggplotly' was not installed ***
Loading required package: gapminder
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'gapminder'
2: In libraryRequireInstall("gapminder") :
*** The package: 'gapminder' was not installed ***
Loading required package: gsubfn
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'gsubfn'
2: In libraryRequireInstall("gsubfn") :
*** The package: 'gsubfn' was not installed ***
Loading required package: magrittr
Warning message:
package 'magrittr' was built under R version 4.2.3
Loading required package: XML
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'XML'
2: In libraryRequireInstall("XML") :
*** The package: 'XML' was not installed ***
Error in layout(., title = "", xaxis = xlayout, yaxis = ylayout) :
unused arguments (title = "", xaxis = xlayout, yaxis = ylayout)
Calls: tryCatch -> tryCatchList -> tryCatchOne -> <Anonymous> -> %>%
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.ExploreHost.SemanticQuery.ScriptVisualCommandFlow.RunInternal(Stream dataShapeResultStream, QueryBindingDescriptor& bindingDescriptor)
at Microsoft.PowerBI.ExploreHost.SemanticQuery.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)

Stack Trace Message:
R script error.
Loading required package: XML
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'XML'
2: In libraryRequireInstall("XML") :
*** The package: 'XML' was not installed ***
Loading required package: htmlwidgets
Warning message:
package 'htmlwidgets' was built under R version 4.2.3
Loading required package: ggplot2
Warning message:
package 'ggplot2' was built under R version 4.2.3
Loading required package: plotly
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'plotly'
2: In libraryRequireInstall("plotly") :
*** The package: 'plotly' was not installed ***
Loading required package: ggplotly
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'ggplotly'
2: In libraryRequireInstall("ggplotly") :
*** The package: 'ggplotly' was not installed ***
Loading required package: gapminder
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'gapminder'
2: In libraryRequireInstall("gapminder") :
*** The package: 'gapminder' was not installed ***
Loading required package: gsubfn
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'gsubfn'
2: In libraryRequireInstall("gsubfn") :
*** The package: 'gsubfn' was not installed ***
Loading required package: magrittr
Warning message:
package 'magrittr' was built under R version 4.2.3
Loading required package: XML
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'XML'
2: In libraryRequireInstall("XML") :
*** The package: 'XML' was not installed ***
Error in layout(., title = "", xaxis = xlayout, yaxis = ylayout) :
unused arguments (title = "", xaxis = xlayout, yaxis = ylayout)
Calls: tryCatch -> tryCatchList -> tryCatchOne -> <Anonymous> -> %>%
Execution halted

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 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.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at System.Windows.Forms.WindowsFormsSynchronizationContext.Send(SendOrPostCallback d, Object state)
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.AllowModalDialogs(Action action)
at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<>c__DisplayClass14_0.<ExecuteOnUIThreadAndHandlePromise>b__0()
at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.ExecuteOnUIThreadAndHandlePromise[T](Func`1 func, IPromiseStore promiseStore, Int64 promiseHandle)
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.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.PowerBI.Client.Windows.WebView2.WebView2Interop.InvokeCs(InteropCall call)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at System.EventHandler`1.Invoke(Object sender, TEventArgs 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.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.118.828.0","ModuleName":"","Component":"","Error":"Error","MethodDef":"","ErrorOffset":"-1:-1","ErrorCode":""}

Snapshot Trace Logs:
C:\Users\poonc\Microsoft\Power BI Desktop Store App\FrownSnapShot328647aa-e622-480b-b7dd-c8970a582ed2.zip

Model Default Mode:
Import

Model Version:
PowerBI_V3

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

Enabled Preview Features:
PBI_sparklines
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_horizontalFusion
PBI_setLabelOnExportPdf
PBI_newCard

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_angularRls
PBI_onObject
PBI_dynamicFormatString
PBI_oneDriveSave
PBI_oneDriveShare
PBI_gitIntegration

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

PowerBIUserFeedbackServices_IsReported:
True

Formulas:

section Section1;

shared Analysis = let
Source = Excel.Workbook(File.Contents("C:\Users\poonc\OneDrive\Desktop\Master Copy.xlsx"), null, true),
Analysis_Sheet = Source{[Item="Analysis",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Analysis_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"JobID", type text}, {"Source", type text}, {"Title", type text}, {"Type of Analyst", type text}, {"Company Name", type text}, {"Job Type", type text}, {"SC or Manager", type text}, {"JD", type text}, {"Hardskill", type text}, {"Qualification", type text}, {"Year of Experience", type any}, {"Industry Grouping", type text}, {"Industry", type text}, {"Company Size Range", type any}, {"Recruiter?", type text}, {"Salary Included?", type text}})
in
#"Changed Type";

shared Salary = let
Source = Excel.Workbook(File.Contents("C:\Users\poonc\OneDrive\Desktop\Master Copy.xlsx"), null, true),
Salary_Sheet = Source{[Item="Salary",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Salary_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Job ID", type text}, {"Range", type text}, {"Salary", type number}})
in
#"Changed Type";

dumbbell chart by maq software not working

Issue with new card visual after publishing to PBI...

Issue with Card Visual Layout After November Power...

Automatically expand table columns to fill availab...

New Button Slicer: Issue with the Grid type of Arr...

List Slicer Button Dimensions Ignored in Service

FabCon is coming to Atlanta

dumbbell chart by maq software not working

Issue with new card visual after publishing to PBI...

Issue with Card Visual Layout After November Power...

Automatically expand table columns to fill availab...

New Button Slicer: Issue with the Grid type of Arr...

List Slicer Button Dimensions Ignored in Service