Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
???
Solved! Go to 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:
- Use R to extract data out of Azure SQL that has not yet been scored by our ML model
- Use R to call the Azure ML web service and send it the unscored data
- Write the output of the Azure ML model back into SQL
- Use R to read scored data into Power BI
- Publish the Power BI file to the Power BI service
- 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
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/
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:
- Use R to extract data out of Azure SQL that has not yet been scored by our ML model
- Use R to call the Azure ML web service and send it the unscored data
- Write the output of the Azure ML model back into SQL
- Use R to read scored data into Power BI
- Publish the Power BI file to the Power BI service
- 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
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.