R script visual not working in service but works in desktop

[Anonymous]

Hi

I have an R-visual using ggplot2, dplyr, and gridextra (all supported packages) that works completely fine in Desktop, but gives me a script runtime error on the service. 

I have a dataset in Workspace1 (premium) that I connect to via my desktop report. Here I make the R-visual and publish to Workspace2 where it gives me the following runtime error:

Script Runtime Error

Attaching package: 'dplyr' The following object is masked from 'package:gridExtra': combine The following objects are masked from 'package:stats': filter, lag The following objects are masked from 'package:base': intersect, setdiff, setequal, union [1] "English_United States.1252" Error in Summary.factor(c(1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, : 'min' not meaningful for factors

Please try again later or contact support. If you contact support, please provide these details.

This is not something I receive on the Desktop version. It works completely fine here. Is there anything I'm missing?

[Anonymous · Accepted solution]

Hi @Anonymous ,

I'd like to suggest you to take a look at below document about use r script in power bi service:

Creating R visuals in the Power BI service#r-scripts-security

R visuals are created from R scripts, which could potentially contain code with security or privacy risks.

These risks mainly exist in the authoring phase when the script author run the script on their own computer.

The Power BI service applies a sandbox technology to protect users and the service from security risks.

This sandbox approach imposes some restrictions on the R scripts running in the Power BI service, such as accessing the Internet, or accessing to other resources that are not required to create the R visual.

For security reasons, some of r script functions has been blocked on power bi service side.(e.g. access external datasource, write/access to specific folder path, import/export file...) 

BTW, r script code with functions you not defined clearly or too complex to calculate(execute over 60s) also not works on service side.(such as, functions with undefined option parameters, undefined clearly data type, complex looping calculation...)
Notice: you can also check following link to confirm your packages are available on power bi service side:

R packages in the Power BI service

Best Regards,

Jay