Forum Discussion

sweidlich's avatar
sweidlich
Advocate II
6 years ago

R ggplot2 figure giving a "script runtime error" when viewed on service

I made a new figure in my report using R's ggplot2 and it looks great in desktop, but I see a "Script Runtime Error" in its window when I publish to web and look at it in my app on the service.

 

After googling around, I saw some really contradictory information. One page said no R scripts work if you "publish to web", while many others said only certain R scripts work (and ggplot2 is one of the okay ones). 

 

The error message provides nothing helpful to me:

 

Script Runtime Error

An error occurred while running the script

Please try again later or contact support. If you contact support, please provide these details.

  • Activity IDedcad8e9-2aa5-4bcc-960b-a212e0d9fb5a
  • Request ID5823f67d-cc06-bbd1-d257-ba0c16b7914b
  • Correlation IDcfdf5043-7ed6-42b0-91c9-46fc414b3a74
  • TimeTue Jun 09 2020 10:20:17 GMT-0700 (Pacific Daylight Time)
  • Service version13.0.13524.230
  • Client version2006.1.01422-train
  • Cluster URIhttps://wabi-west-us-redirect.analysis.windows.net/

 

And below is my R code for my ggplot2, which is a simple scatterplot and a spline:

 

# The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamble for your script:

# dataset <- data.frame(Date_Index, Positive_Cases)
# dataset <- unique(dataset)

# Paste or type your script code here:
powerbi_rEnableShowText = 1
library(ggplot2)
ggplot(dataset, aes(x=Date_Index, y=Positive_Cases)) +
geom_point(colour = "dodgerblue", size = 2) +
geom_smooth(span = 0.25, colour = "darkorange", size = 3, se=FALSE) +
geom_line(size = 0.1, colour = "gray75") +
theme_minimal() +
labs(y="Positive Cases", x= "Date Index", size = (4))

 

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    This may be related?

     

    https://powerbi.microsoft.com/en-us/support/

     

    Power BI customers using Python or R visuals together with May release of the Power BI Personal Gateway may see the following error message when trying to refresh: “ADO.NET: Failed to find or load the registered .Net Framework Data Provider”. As a workaround users may revert to the April release of the Power BI Personal Gateway. Engineers are working on a fix and expect it to be deployed by end-of-day 06/09/2020.

  • sartoris's avatar
    sartoris
    Frequent Visitor
    6 years ago

    I got a similar error today:

    Script Runtime Error
    An error occurred while running the script
    Please try again later or contact support. If you contact support, please provide these details.
    Activity ID: 155f5684-ceb5-4a62-9644-1094a60367d2
    Request ID: d44fae9d-6edc-7891-869b-e90a5e5fe3c6
    Correlation ID: e2066f6c-7d9a-c96b-a970-a91b84bdbbab
    Time: Wed Jun 10 2020 10:23:09 GMT-0700 (Mountain Standard Time)
    Service version: 13.0.13524.230
    Client version: 2006.1.01422-train
    Cluster URI: https://wabi-west-us-redirect.analysis.windows.net/

    R Script:

    library(VennDiagram)
    listdataset <- lapply(dataset, function(x) { x } )
    listcolor <- c("red", "yellow", "green", "blue", "gray")
    listcolor <- head(listcolor, ncol(dataset))
    venndiagram <- venn.diagram(listdataset, filename=NULL, na="remove", fill = listcolor, margin=0.1)
    grid.draw(venndiagram)
  • kh4hk's avatar
    kh4hk
    Regular Visitor
    6 years ago

    I have same error for all my R visuals, even the ones that were working in the Service as of last week are now showing Script Error.