Use Power Query To Import Azure Ml. Schedule a refresh of the data using the Personal Gateway which triggers a scheduled re-run of our R script and brings in new predictions. Power Query is an Excel add-in that brings data discovery and data access and powerful transformations to Excel.

In this video how we able to create a model in Azure Ml Studio then. Then you able to see the imported dataset in your Azure ML dataset list. Select the my-sklearn-service that you created from the Train and deploy a machine learning model tutorial.
Locate the folder containing the files you want to combine.
Using Power Query in Excel to score against Azure ML web services. I am using a script instead of the Reader module because I need to do multiple queries and transform the returned data. Consume it in Power bI Service data Flow has been shown. Then download the dataset for titanic from here.