Forum Discussion
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:
- https://radacad.com/power-bi-and-azure-ml-make-them-work-with-power-query
- 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!
This may be of interest to you
Start developing custom connectors for Power Query | Microsoft Docs
Authentication is the biggest hurdle, usually. Not sure if that is a factor in your scenario.
1 Reply
- lbendlin
Super User
This may be of interest to you
Start developing custom connectors for Power Query | Microsoft Docs
Authentication is the biggest hurdle, usually. Not sure if that is a factor in your scenario.