Forum Discussion
Azure ML and Power BI connectivity issue
Hi,
I am trying to implement Azure ML with Power BI using R. But i got below error when i run R script in Power BI.
## Set the workspace id
wsid = "paste your workspace id here within the quotation marks"
## Set the workspace authentication key
auth = "paste your authentication token here within the quotation marks "
## Input the name of the Experiment
serviceName = "paste your service’s name here within the quotation marks "
## Load the AzureML library if not previously installed: install.packages("AzureML")
library("AzureML")
ws <- workspace(wsid,auth)
s <- services(ws, name = serviceName)
ds <- consume(s,dataset)
Error:
Unable to connect
We are encoutered error while trying to connect
Details: "ADO.NET: R script error.
Error in consume(s, dataset) : object 'dataset' not found
Execution halted
Please help me on it.
Thanks
Srinivas
Hi Anonymous,
Were you attempting to access and load the dataset hosted on Azure ML in Power BI desktop or evaluate an Azure ML web service with new data uploaded to AzureML from Power BI desktop?
From the error prompt, inside the R script, you didn't define any dataset before using consume() function. I would suggest you refer to this article to check the proper usage of download.datasets() or consume(). Below screenshot shows an example mentioned in the link:
Best regards,
Yuliana Gu
2 Replies
v-yulgu-msftMicrosoft Employee
Hi Anonymous,
Were you attempting to access and load the dataset hosted on Azure ML in Power BI desktop or evaluate an Azure ML web service with new data uploaded to AzureML from Power BI desktop?
From the error prompt, inside the R script, you didn't define any dataset before using consume() function. I would suggest you refer to this article to check the proper usage of download.datasets() or consume(). Below screenshot shows an example mentioned in the link:
Best regards,
Yuliana Gu