Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |