R in Power BI Service does not work

[carlosyanez]

Hi !

I have a dashboard that is using R visualisations, both "R scripts" and an R custom visual .  Both visualisation types work perfectly fine in Power BI Desktop, but when in the Service I get the below error message for all of them:

Script Runtime Error

An error occurred while running the script

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

Activity ID: 100b9750-374e-442d-ad84-2b26649ea685
Request ID: af07e5b8-aa61-130b-4c97-86364f2e3196
Correlation ID: 87b03449-f8ea-58a1-3600-ca7d61d07995
Time: Fri Feb 17 2023 23:15:28 GMT+1100 (Australian Eastern Daylight Time)
Service version: 13.0.20105.47
Client version: 2302.2.12402-train
Cluster URI: https://wabi-west-europe-e-primary-redirect.analysis.windows.net/

I've tried across two Pro tenancies - for one I am the admin and I can see that R/Python visuals and uncertified custom visuals are  enabled (In Admin Portal > Tenant Settings). As per the documentation, I am only using CRAN packages (tidyverse and {echarts4r}).

Unfortunately, the error message is not allowing to undestand what's going on. What am I missing here?

Kind Regards,

Carlos

[carlosyanez · Accepted solution]

After tinkering a bit, I think the issue is related to Power BI not correctly passing column names with spaces, which cause the runtime to crash. When I removed the spaces in names, Power BI service was able to to render the visuals.

[lbendlin]

You need to use a personal gateway to run R or Python visuals on the Power BI Service.

[carlosyanez]

I am a bit confused, the documentation does not mention this requirement : https://learn.microsoft.com/en-us/power-bi/visuals/service-r-visuals . Can you please clarify?

[lbendlin]

Sorry, my bad. The limitation is for service refresh of Power Query queries containing R script, not for the rendering.