Forum Discussion

chotu27's avatar
chotu27
Post Patron
9 years ago
Solved

Azure machine learning with power bi dataset

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 ???
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi chotu27,

    Workflow

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

     

    arch

     

    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. :smileyhappy:

     

    Regards