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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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.

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors