Forum Discussion

pcray's avatar
pcray
Frequent Visitor
8 years ago
Solved

cant display visual - R script error

Hi,

Ive just downloaded and run the windows r exe 3.4.3 and when i go into power bi desktop i see the following errors.

anyone know what i can do to fix this issue?

 

 

Feedback Type:
Frown (Error)

Timestamp:
2018-02-20T18:23:26.2238244Z

Local Time:
2018-02-20T18:23:26.2238244+00:00

Session ID:
1a95e93c-8216-4111-9630-0bd67d415e40

Release:
February 2018

Product Version:
2.55.5010.641 (PBIDesktop) (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 messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'htmlwidgets'
2: In libraryRequireInstall("htmlwidgets") :
*** The package: 'htmlwidgets' was not installed ***
Loading required package: ggplot2
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: scales
Loading required package: forecast
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'forecast'
2: In libraryRequireInstall("forecast") :
*** The package: 'forecast' was not installed ***
Loading required package: zoo
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'zoo'
2: In libraryRequireInstall("zoo") :
*** The package: 'zoo' was not installed ***
Error in plotly_build(p1a) : could not find function "plotly_build"
Execution halted


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

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

Peak Virtual Memory:
34 GB

Private Memory:
288 MB

Peak Working Set:
451 MB

IE Version:
11.248.16299.0

User ID:
0f9f0b28-6e9f-41dd-8379-d24869742822

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

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\Peter\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot707305532.zip

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

Enabled Preview Features:
PBI_customVisualsGallery

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
CustomConnectors
PBI_reportBookmarks
PBI_AdobeAnalytics
PBI_qnaExplore
PBI_variationUIChange
PBI_HanaV2

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted

Cloud:
GlobalCloud

Activity ID:
null

Time:
Tue Feb 20 2018 18:21:07 GMT+0000 (GMT Standard Time)

Client Error Code:
ServiceErrorToClientError

Error Details:
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 messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'htmlwidgets'
2: In libraryRequireInstall("htmlwidgets") :
*** The package: 'htmlwidgets' was not installed ***
Loading required package: ggplot2
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: scales
Loading required package: forecast
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'forecast'
2: In libraryRequireInstall("forecast") :
*** The package: 'forecast' was not installed ***
Loading required package: zoo
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'zoo'
2: In libraryRequireInstall("zoo") :
*** The package: 'zoo' was not installed ***
Error in plotly_build(p1a) : could not find function "plotly_build"
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 messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'htmlwidgets'
2: In libraryRequireInstall("htmlwidgets") :
*** The package: 'htmlwidgets' was not installed ***
Loading required package: ggplot2
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: scales
Loading required package: forecast
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'forecast'
2: In libraryRequireInstall("forecast") :
*** The package: 'forecast' was not installed ***
Loading required package: zoo
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'zoo'
2: In libraryRequireInstall("zoo") :
*** The package: 'zoo' was not installed ***
Error in plotly_build(p1a) : could not find function "plotly_build"
Execution halted
---> Microsoft.PowerBI.Radio.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 messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'htmlwidgets'
2: In libraryRequireInstall("htmlwidgets") :
*** The package: 'htmlwidgets' was not installed ***
Loading required package: ggplot2
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: scales
Loading required package: forecast
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'forecast'
2: In libraryRequireInstall("forecast") :
*** The package: 'forecast' was not installed ***
Loading required package: zoo
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'zoo'
2: In libraryRequireInstall("zoo") :
*** The package: 'zoo' was not installed ***
Error in plotly_build(p1a) : could not find function "plotly_build"
Execution halted

at Microsoft.PowerBI.Radio.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, EntityDataModel model, IConceptualSchema schema, DataQuery query, Int32 queryId, ServiceErrorStatusCode& serviceErrorStatusCode)
at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.ProcessAndWriteSemanticQueryCommands(IQueryResultsWriter queryResultsWriter, ExecuteSemanticQueryRequest request, IConceptualSchema conceptualSchema, EntityDataModel model)

DPI Scale:
150%

Supported Services:
Power BI

Formulas:

 

  • Hi pcray

     

    Looks like you need to install a bunch of packages into your instance of R (outside Power BI)

     

    Just some you need, scanning down the list are:

     

    • XML
    • plotly
    • forecast
    • zoo

2 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee

    Hi pcray

     

    Looks like you need to install a bunch of packages into your instance of R (outside Power BI)

     

    Just some you need, scanning down the list are:

     

    • XML
    • plotly
    • forecast
    • zoo
    • pcray's avatar
      pcray
      Frequent Visitor

      thank you.

      that did it.