R Script Visuals Stopped Working

[econconsultant]

We have a Power BI dashboard that we deploy in our client's SharePoint. It is a Premium Workspace. For the past year, it has worked fine. However, when I updated it about two weeks ago, the visuals that use R script stopped working. I also tested them in my company's SharePoint, and they also did not work. They have always worked in the past, and they continue to work in the Desktop version right now, but stopped working in SharePoint.

Here is the error message:

[v-nmadadi-msft]

Hi @econconsultant 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @econconsultant 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[v-nmadadi-msft · Accepted solution]

Hi @econconsultant  ,
Thanks for reaching out to the Microsoft fabric community forum.

Please cross check these points:

1)  Publish to web isn't supported for R visuals. Reports with R visuals can still be published publicly, but any R visuals will not render (charts will appear empty).

2) Supported Current R runtime is R 4.3.3 for Power BI Service, make sure your report is using the supported version only.

3) R visuals require a Power BI Pro or Premium Per User (PPU) license to render in reports, refresh, filter, and cross-filter. Users of free Power BI can consume only reports that are shared with them in Premium workspaces.

The following table describes R visuals capabilities based on licensing.

I hope this information helps. Please do let us know if you have any further queries.
Thank you

[tayloramy]

Hi @econconsultant, 

It appears that you are trying to use an unsupported visual. Not all R/Python visuals are supported in the service.  

Here's a list of packages that are supported: https://learn.microsoft.com/en-us/power-bi/visuals/service-r-visuals

Can you share what packages you're using? 

ALso verify that the workspace is backed by a Fabric capacity. Lastly, note this from the documentation: 

For security and privacy reasons, we currently don't support R packages that provide client-server queries over the World-Wide Web (such as RgoogleMaps) in the service. Networking is blocked for such attempts. For more information, see R packages in the Power BI service for a list of supported and unsupported R packages.
Create advanced analytics and visualizations using R scripts - Power BI | Microsoft Learn

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

[econconsultant]

I am using scales, ggplot2, dplyr, and ggrepel. When I run the same code in R, using the version of R and version of those libraries suggested by Power BI, the code works fine.

As an additional consideration, the most basic of an R plot does not even work. The code below (which is probably the most basic plot anyone can do in R) works in the desktop version of Power BI but not the SharePoint version.

dataset$count <- as.numeric(dataset$r_outcome)

plot(dataset$count)

[tayloramy]

Hi @econconsultant, 

When you say SharePoint, is your report sitting in SharePoint, or is it sitting in a Premium workspace backed by a Fabric capacity?  

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

[GilbertQ]

Hi @econconsultant 

Based on the error it says an unsupported visual for rendering. Could it possibly be that you updated your R visuals when you updated the report and that has now stopped your power BI report from rendering?

Here is a list of supported visuals and their version: Learn which R packages are supported - Power BI | Microsoft Learn

[econconsultant]

It has to be something unrelated to the code. The most basic of an R plot does not even work. The code below (which is probably the most basic plot anyone can do in R) works in the desktop version of Power BI but not the SharePoint version. Hence, I suspect something is messing up in the server.

dataset$count <- as.numeric(dataset$r_outcome)

plot(dataset$count)