Forum Discussion
R Script Runtime Error
I created a pbix using the VennDiagram R Visual. I installed MS R Open v3.4.4 locally. I am using the VennDiagram R package v1.6.20. The diagram displays fine on my desktop. I published it to app.powerbi.com and all other visuals display correct but the Venn diagram. The dataset has less than 5000 records. I get this error:
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: 3a68f729-afd8-e73f-f828-127a447a4aad
Correlation ID: 37987b20-4b97-1e92-ff40-dc47809e228f
Time: Wed Jun 10 2020 11:50:38 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/
Here is the 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)
This is me contacting support. If there is a better way to contact support, please let me know.
I did submit a ticket with Microsoft support and they got back to me more quickly than I had thought - a pleasant surprise! They also admitted:
'The issue was due to a bug from Power BI.
The fix for the bug was deployed yesterday. Hence, you are able to successfully view the visuals today.'That, too, was a pleasant surprise. Kudos to Microsoft support.
11 Replies
According to this
https://docs.microsoft.com/en-us/power-bi/connect-data/service-r-packages-support
it's a supported package. Has it worked before? I am asking because we have seen similar errors recently in our tenant, also with supported packages that previously worked.
You're not using a personal gateway, right?
I am not using a personal gateway. Nor am I using R as a datasource. I am using the script to provide visualization of an existing dataset.
Doesn't matter where you want to run your R script, be it in Power Query or in the visual. They still need to access the "local" R libraries and engine. "local" in this case meaning the gateway or the service.
For this kind of unknown error that we cannot reproduce, create a support ticket is recommended.
BTW, R scripts are supported only for personal gateway mode. Create advanced analytics and visualizations using R scripts in Power BI
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Anonymous can you please point to where in the documentation it says that only personal gateway mode is supported?
Sroll down to see the very last FAQ:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-modePaul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
