Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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.
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
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
Hi,
I have reported this issue: CRI 52371475. Any news I will post here.
Best Regards!
Dale
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
User | Count |
---|---|
18 | |
11 | |
5 | |
4 | |
3 |