Azure machine learning with power bi dataset

[chotu27]

Hi all,

In Azure machine Learning can we use Source as power bi dataset or any to connect with Power bi data sets

Please Help
???

[jbulk]

Here is a detailed 2 part blog with diagrams, code snippets and links.

https://www.linkedin.com/pulse/match-made-heaven-part-1-2-anthony-bulk/

https://www.linkedin.com/pulse/match-made-heaven-part-2-anthony-bulk/

[v-ljerr-msft · Accepted solution]

Hi @chotu27,

Workflow

By the end of the tutorial we will have set up the following workflow:

The high level steps we will be performing are as follows:

1. Use R to extract data out of Azure SQL that has not yet been scored by our ML model
2. Use R to call the Azure ML web service and send it the unscored data
3. Write the output of the Azure ML model back into SQL
4. Use R to read scored data into Power BI
5. Publish the Power BI file to the Power BI service
6. 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)

---

In addition, here is a good article about how to integrate Azure Machine Language with Power BI for your reference. 

Regards

[Seth_C_Bauer]

@chotu27 Greg Deckler did a presentation awhile ago showing how he bridged the gap using R I believe... here is the link, you can register and it should take you to a recording if you are interested.