Azure ML and Power BI Error on Service but working on Desktop tool

[ranaankit]

Hi All,

When we are trying to connect to Azure ML using R from Power BI we are getting below error on service account:

Loading required package: bitops Error in function (type, msg, asError = TRUE) : Could not resolve host: ussouthcentral.services.azureml.net  

But the same code is working fine in Power BI Desktop File. Package bitops is already included. Tried alot of things but still no progress every time I publish to service account it gives error. 

# Accept SSL certificates issued by public Certificate Authorities
options(RCurlOptions = list(sslVersion=1,verbose = TRUE,cainfo = system.file("CurlSSL", "cacert.pem", package = "RCurl"), ssl.verifypeer = FALSE))

curlPerform(url = "https://ussouthcentral.services.azureml.net/workspaces/xxxx/services/xxxx/execute?api-version=2.0&de...",
httpheader=c('Content-Type' = "application/json", 'Authorization' = authz_hdr),
postfields=body,
writefunction = h$update,
headerfunction = hdr$update,
verbose = TRUE,
ssl.verifypeer = FALSE
)

Thanks In Advance

[v-qiuyu-msft]

Hi @ranaankit,

Regarding this issue, I would suggest you create a support ticket to get dedicated support. 

Best Regards,
Qiuyun Yu 

[lgroger]

Hi @ranaankit 

I'm getting a similiar error when moving my R visual to Power BI service.  Can you share how you solved it if you were able to?

Loading required package: bitops Error in function (type, msg, asError = TRUE) : Could not resolve host: ******

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

[lgroger]

For anyone who might be having this issue, I put in a ticket with Power BI and they said it's not possible to load data from the internet through R even though Rcurl is listed as a supported package.

https://docs.microsoft.com/en-us/power-bi/service-r-packages-support#requirements-and-limitations-of...

"For security and privacy reasons, R packages that provide client-server queries over the World-Wide Web (such as RgoogleMaps) in the service, are not supported. Networking is blocked for such attempts. See the following section for a list of supported and unsupported R packages."