Power BI Service R Script Runtime error

[arajani40]

Hi Support, my R visual created some time back was running absolutely fine till last week but noticed that it is giving an error with the below details now:

Activity ID: 06a8c3e2-1bdd-444e-830b-12b1942c2594
Request ID: 374c2c5f-bcc3-064f-4fa7-e464f1f63f03
Correlation ID: 4da864bd-0050-cdcf-e05e-6e4622650cd7
Time: Wed Apr 20 2022 14:15:48 GMT+1000 (Australian Eastern Standard Time)
Service version: 13.0.18082.40
Client version: 2204.2.10821-train
Cluster URI: https://wabi-australia-east-a-primary-redirect.analysis.windows.net/

Rscript from PowerBi Desktop:

library(ggplot2)

library(stringr)

library(tidyverse)

library(dplyr)

dataset$Category<-factor(dataset$Category,levels=c("Formal education","External and internal short courses","Technical conferences and learned society meetings","Publications","On-the-job skill enhancement","Private reading of learned publications","Structured mentoring","Service to industry","Peer reviewing","Other activities"))

dataset<-mutate(dataset,Eligible_Hours=ifelse(Total_Hours<=Maximum_Hours,Total_Hours,Maximum_Hours))

dataset<-mutate(dataset,Excess_Hours=ifelse(Total_Hours>Maximum_Hours,Total_Hours-Maximum_Hours,0))

df<-gather(dataset,"HoursType","Hours",3:5)

df<-filter(df,HoursType!="Maximum_Hours")

g<-ggplot(data=df,aes(x=Category,y=Hours,fill=HoursType))+

geom_col(stat="identity",width=0.5,position=position_stack(reverse=T))+

scale_fill_manual(values=c("#005E85","#CBDBE5"))+

#geom_col(aes(y=Eligible_Hours),fill="#00AAC3")+

scale_x_discrete(labels = function(x) str_wrap(x, width = 15))+

geom_text(aes(label=ifelse(HoursType=="Eligible_Hours", Hours,"")),position=position_dodge(0.1),vjust=-0.5,size=5)+

theme_minimal()+

theme(legend.position="top",axis.text=element_text(size=14),

axis.title=element_text(size=14,face="bold"))+labs(fill="")

g

Request you to please help. Thanks!

[albertoflx]

I have exactly the same issue. The visual runs fine in the desktop version, but it fails when is published to the web service (Runtime error). I double checked, and it has no conflict with the packages (Im using ggplot and dplyr). 

[MatBaker · Accepted solution]

I believe I have a very simlar issue. It would appear that something has changed in the way that PowerBI handles R visuals when published. Having now rebuilt my visual, it now works on the desktop but not when published. Have recreated the visual and tried tweaking a few different things (librarys, syntax etc), I've updated to the latest version of desktop and run a full update of R and RStudio on my machine, however, I'm still getting the same unhelpful syntax error.

[arajani40]

Hi MatBaker, thank you for your reply. I believe Microsoft have deployed the changes on 24/04/2022. My R-visuals are now working fine on Power Bi Service. Appreciate your help.

[MatBaker]

Cross reference with this post: 

https://community.powerbi.com/t5/Issues/R-Matrix-Visual-Script-Runtime-Error/idc-p/2464803