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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
laurentWeave
New Member

R script only work localy

I have a R script embeded in a page that worked perfectly localy in my Power BI Desktop application but is not working when I publish on Power BI.

 

 

library(dplyr)
library(ggplot2)
library(lubridate) # for working with dates
#evolution du CA dans le temps


dataset$date_gagne <- strtrim(dataset$date_gagne,c(10))


dt2 <- dataset %>% filter (!is.na(ca_entite)) %>%
  mutate(date = ymd(date_gagne)) %>%
  arrange(date_gagne) %>%
  mutate(cumsum = cumsum(ca_entite))

dt2 %>% ggplot(aes(date, cumsum)) + geom_line(colour = "red",size = 3) +
  xlab("") + ylab("CA BT") + theme_linedraw(base_size = 11, base_family = "") +
  labs(title = "Evolution du CA dans le temps") 

 

The error message is :

 

 Attaching package: 'dplyr'
 The following objects are masked from 'package:stats':
 filter, lag
 The following objects are masked from 'package:base':
 intersect, setdiff, setequal, union
 Error in mutate_impl(.data, dots) : 
 (converted from warning) unable to identify current timezone 'C':
 please set environment variable 'TZ'
 In addition: Warning messages:
  1: package 'dplyr' was built under R version 3.2.5 
  2: package 'ggplot2' was built under R version 3.2.5 
  3: package 'lubridate' was built under R version 3.2.4 

 

6 REPLIES 6
Anonymous
Not applicable

I have a similar problem with my R script working locally but not in the shared workspace. Other ggplot2 graphs without dplyr are working so I assume that it is dplyr causing the problem. However, this error makes having R scripting in Power BI nigh on pointless because for me it's particular value is being able to easily manipulate the data.

 

I can't post my code or the error because the website keeps throwing errors when I try.

v-viig
Community Champion
Community Champion

Hello @laurentWeave

 

Thank you for reaching us.

We'll involve our R-script developer to assist you.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

laurentWeave
New Member

I have a R script that works localy but is not working when I publish it on power BI

 

library(dplyr)
library(ggplot2)
library(lubridate) # for working with dates
#evolution du CA dans le temps


dataset$date_gagne <- strtrim(dataset$date_gagne,c(10))


dt2 <- dataset %>% filter (!is.na(ca_entite)) %>%
  mutate(date = ymd(date_gagne)) %>%
  arrange(date_gagne) %>%
  mutate(cumsum = cumsum(ca_entite))

dt2 %>% ggplot(aes(date, cumsum)) + geom_line(colour = "red",size = 3) +
  xlab("") + ylab("CA BT") + theme_linedraw(base_size = 11, base_family = "") +
  labs(title = "Evolution du CA dans le temps > prod BT", subtitle = "CA BT") 

 

The error I got is the following:

Attaching package: 'dplyr'
 The following objects are masked from 'package:stats':
 filter, lag
 The following objects are masked from 'package:base':
 intersect, setdiff, setequal, union
 Error in mutate_impl(.data, dots) : 
 (converted from warning) unable to identify current timezone 'C':
 please set environment variable 'TZ'

 In addition: Warning messages:
 
 1: package 'dplyr' was built under R version 3.2.5 
 2: package 'ggplot2' was built under R version 3.2.5 
 3: package 'lubridate' was built under R version 3.2.4 
 
 

Hi @laurentWeave,

 

I have consulted the Product Team. I will post the result here later.

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

 

I have reported this issue: CRI 52371475. Any news I will post here. 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi,

 

I'm having the same issue with GGPLOT2 in the service.

Why is that R script is running 3.2.2 and is not patched to a newer version that supports newer R packages in the service?

 

Thanks

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.