Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
arajani40
Regular Visitor

Power BI Service R Script Runtime error

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!
1 ACCEPTED SOLUTION
MatBaker
Frequent Visitor

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.

View solution in original post

4 REPLIES 4
albertoflx
Regular Visitor

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
Frequent Visitor

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.

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.