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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

August Carousel

Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors