Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Connecting to ML Studio Web Services Through M-Language in Power Query (Not R)

Hi everyone,

 

I am currently developing a dashboard in which I would like to use some ML models. I looked into Azure Machine Learning and since it is a proof of concept I don't have any financial resources at the moment. Therefore, I will be using the depreciated but free Machine Learning Studio Classic (https://studio.azureml.net/). On this platform it is possible to make a custom web service and then connect to it. Within Power BI, there is a way to connect with these web services by running an R script as demonstrated by these 2 articles:

  1. https://radacad.com/power-bi-and-azure-ml-make-them-work-with-power-query
  2. https://powerbi.microsoft.com/fr-fr/blog/power-bi-azure-ml/

 

While this is works, I don't see it as the ideal solution for me as I would like to publish te reports on our service to show off the end product. If I make use of R-scripts, I should have a personal gateway to a computer/server with an R installation, which once again, I do not have at my disposal.

 

I would like to know whether it is possible to to the exact same, but straight from M-scripts in Power Query, without using R. Microsoft released a manual on how to consume the web services with the logic written out in C#, Python, R and Javascript; https://docs.microsoft.com/en-us/azure/machine-learning/classic/consume-web-services. Is there anyone that can tell me whether it is possible to translate this logic to a blank query in Power Query in M language and help me with this? As an extra resource, I included an article of someone connecting to the Twitter API from Power Query and it seems like there is some shared logic: https://chris.koester.io/index.php/2015/07/16/get-data-from-twitter-api-with-power-query/. 

 

Thanks in advance!