Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

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

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.