R and Python visualizations in PBI service (Script Runtime Error)

[Anonymous]

Hello, I want to use R visual or Python one, doesn't matter, I'm using the packages that are supported in PBI and it works in desktop version, however, it doesn't work in PBI service(online workspace). My data is taken from MySQL db from remote server, can it be a problem that break the visual? If not, what it can be? 

here is one example of the issue I get, 
Activity ID: 3d904c9f-728e-4b65-9dd0-a73016537222
Request ID: 2edcece1-fab1-8ddf-58f4-e9a934b4307c
Correlation ID: d9eaea54-2d85-fb33-f8e5-8325055db571
Time: Wed Dec 21 2022 15:25:49 GMT+0200 (Eastern European Standard Time)
Service version: 13.0.19635.59
Client version: 2212.1.11454-train
Cluster URI: https://wabi-west-europe-b-primary-redirect.analysis.windows.net/

(I DO HAVE THOSE PACKAGES INSTALLED AND THEY ARE SUPPORTED IN PBI)
Thanks in advance!!!

[v-jingzhang]

Hi @Anonymous 

Check whether the package versions are supported in Power BI Service: Learn which R packages are supported - Power BI. The version of R deployed in the Power BI service is also probably different from that on your local computer: Create and use R visuals in Power BI - Power BI

According to the R error message, it seems the issue is caused by data. Did you connect to the MySQL DB via Import or DirectQuery? Does this error happen right after you publish the pbix to PBI Service? Did you refresh the dataset before having this error?

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!

[Anonymous]

I connect MySQL DB via DirectQuery, I have the issue right after publishing, I didn't refresh the dataset

[v-jingzhang]

Hi @Anonymous 

Did you add the same MySQL DB to a gateway and choose that gateway for this dataset in Power BI Service? Since it has DirectQuery tables, you need to use an on-premises data gateway for Power BI Service to get data from the data source if this data source is not in the cloud.

Jing