New Azure Machine Learning & Excel

Question

Hi All

I have been working with Azure Machine Learning Studio (Classic) and have always found its integration with Excel super mega useful.

All I had to do was to get the URI and the API_Key of my web service and paste them on the Azure Machine Learning Add-In, that I had downloaded. Easy and useful.

However, with the new Azure Machine Learning studio that does not seem possible any more.

Under the new Azure Machine Learning studio when I deploy a model I get a REST endpoint and that's it? !? I cannot find anywhere the API_key for my web service. I cannot even find a web service section as such.

1. How do I get the API_Key for the web service I need?
2. If I get the API_Key could I use it on the Excel Azure Machine Learning add-in. It looks as if this is no longer an option and we need to start using Power BI instead.
3. I have read this interesting post where someone mentions a work around that consist of creating an Excel macro. Is this the best option? https://learn.microsoft.com/en-us/answers/questions/236781/consume-scoreing-api-in-excel.html

Thank you

Answer 1

Hi, thanks for reaching out. The new AzureML integration with Excel isn't supported at this time. More details are provided on this thread. The alternative approach would be to use a Client or PowerBI to consume the model. For future reference, you can find your webservice endpoint and keys under Studio > Endpoints > Endpoint > Consume.

--please don't forget to Accept Answer if the reply is helpful. Thanks.--