R Script Runtime Error in Power BI

[Anonymous]

Hi Support,

I created a PowerBI using the R Visual. The K-M plot displays fine on my desktop. I published it to app.powerbi.com and all other visuals display correct but the K-M Plot using R. I get this error:

Activity ID: [PII masked by MSFT]

Request ID: [PII masked by MSFT]

Correlation ID: [PII masked by MSFT]

Time: Sat Nov 02 2024 14:01:44 GMT-0500 (Central Daylight Time)

Service version: 13.0.24547.47

Client version: 2410.3.21423-train

Cluster URI: 

BTW, personal gateway already enabled.

Thanks.

[shafiz_p · Accepted solution]

Hi @Anonymous 
Ensure that the R packages you are using in your script are supported by Power BI Service. Not all R packages available in Power BI Desktop are supported in the Power BI Service.

Power BI Service has a timeout limit for R script execution. If an R visual calculation exceeds 60 seconds, the script times out and displays an error.

Try simplifying your R script to the most basic version that still produces a plot. This can help identify if a specific part of the script is causing the issue.

Run your R script locally in RStudio or another R environment to ensure there are no errors. Sometimes, issues that don’t appear in Power BI Desktop can be caught in a local R environment.

Read the below articles for consideration and limitation:

https://learn.microsoft.com/en-us/power-bi/visuals/service-r-visuals#r-scripts-security 

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-r-visuals 

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

[Anonymous]

Hi @Anonymous ,

Did SaiTejaTalasila  and shafiz_p  responses solve your problem? If the problem has been solved you can mark the reply for the standard answers to help the other members find it more quickly. If not, please point it out.

Best Regards,

Neeko Tang

[SaiTejaTalasila · Accepted solution]

Hi @Anonymous ,

Please refer this and check whether the r package you are using is supported by power bi or not.

https://learn.microsoft.com/en-us/power-bi/connect-data/service-r-packages-support

Open a ticket with Microsoft support team for more details.

Thanks,

Sai Teja 

[shafiz_p · Accepted solution]

Hi @Anonymous 
Ensure that the R packages you are using in your script are supported by Power BI Service. Not all R packages available in Power BI Desktop are supported in the Power BI Service.

Power BI Service has a timeout limit for R script execution. If an R visual calculation exceeds 60 seconds, the script times out and displays an error.

Try simplifying your R script to the most basic version that still produces a plot. This can help identify if a specific part of the script is causing the issue.

Run your R script locally in RStudio or another R environment to ensure there are no errors. Sometimes, issues that don’t appear in Power BI Desktop can be caught in a local R environment.

Read the below articles for consideration and limitation:

https://learn.microsoft.com/en-us/power-bi/visuals/service-r-visuals#r-scripts-security 

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-r-visuals 

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz