question

IvanCasanaGallen-3736 avatar image
0 Votes"
IvanCasanaGallen-3736 asked GiftA-MSFT answered

New Azure Machine Learning & Excel

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://docs.microsoft.com/en-us/answers/questions/236781/consume-scoreing-api-in-excel.html


Thank you





azure-machine-learningazure-machine-learning-studio-classicazure-machine-learning-inference
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

GiftA-MSFT avatar image
0 Votes"
GiftA-MSFT answered

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.--

5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.