Error "cannot open the connection" for R-Visual after publishing

[Anonymous]

Hello, 

I have a dashboard with Tables and R-Visuals. In the R-Visuals the dataset refers to a csv-file 

`dataset` = read.csv(...)
In Power BI Desktop it works fine, but after publishing in Power BI Web, the R-Visuals get an error:
"Error in file(file, "rt") : cannot open the connection In addition: Warning message: In file(file, "rt") : cannot open file '//... .csv': No such file or directory"

I´ve tried different datasources from different directories, but none helped. Also tried with "setwd" but the following error appears:
"Error in setwd("//...") : cannot change working directory"

What could be a reason why the data source can´t be found in Power BI Web? Is there a setting wrong? 

Thanks in advance,
Simon

[Anonymous]

Hi @Anonymous ,

I'd like to suggest you take a look at the document below to know limitations about R script on power bi service.

https://docs.microsoft.com/en-us/power-bi/visuals/service-r-visuals.

R visuals in the Power BI service have a few limitations:

• R visuals support is limited to the packages identified in Learn which R packages are supported. There currently is no support for custom packages.

• Data size limitations – data used by the R visual for plotting is limited to 150,000 rows. If more than 150,000 rows are selected, only the top 150,000 rows are used and a message is displayed on the image.

• Calculation time limitation – if an R visual calculation exceeds 60 seconds the script times out, resulting in an error.

• R visuals are refreshed upon data updates, filtering, and highlighting. However, the image itself is not interactive and does not support tool tips.

• R visuals respond to highlighting other visuals, but you cannot click on elements in the R visual in order to cross filter other elements.

• R visuals are currently not supported for the Time data type. Please use Date/Time instead.

• R Visuals do not display when using Publish to web.

• R visuals currently do not print with dashboard and reports printing

• R visuals are currently not supported in the DirectQuery mode of Analysis Services

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.