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 Pow...
Need Help
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.