cancel
Showing results for 
Search instead for 
Did you mean: 
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
simek
Frequent Visitor

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.

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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors