Forum Discussion

MaybrickLR's avatar
MaybrickLR
Frequent Visitor
3 years ago
Solved

Help with Azure AutoML endpoint connecting to Power BI Desktop

I have a nice model in Azure AutoML.  I've tried 8 ways from Sunday to connect it to Power BI as an End Point.  I've read just about every post out there from Microsoft on how to connect, and how to consume.  So simply posting a link is of no value to me, I've read it. 

I really need guidance and help with this.  It's really causing a delay in a project I'm working on.  I will be happy to compensate for your time.

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi MaybrickLR ,

    There is an Azure Machine Learning Studio web service that can be used to integrate with Power BI. To use it, you will need to create a web service in Azure Machine Learning Studio and then connect to it from Power BI. Here are the steps: 1. In Azure Machine Learning Studio, create a predictive experiment and publish it as a web service. 2. In Power BI, go to the "Get Data" menu and select "Azure". Then select "Azure Machine Learning Web Service". 3. Enter the URL and API key for the web service you created in Azure Machine Learning Studio. 4. Select the inputs and outputs for your Power BI report.

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi MaybrickLR ,

    Please have a try.

    First, have you checked that the necessary permissions are set up in Azure and Power BI? You may need to grant access to the model in Azure and create a service principal in Power BI.

    Second, have you tried using the Azure Machine Learning Power BI connector? This connector allows you to easily connect to your Azure AutoML model and use it in Power BI.

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details .

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • MaybrickLR's avatar
    MaybrickLR
    Frequent Visitor

    All permissions are correct in the Admin portal.  I cannot find an Azure ML Power BI connector.  Where is it?

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi MaybrickLR ,

      There is an Azure Machine Learning Studio web service that can be used to integrate with Power BI. To use it, you will need to create a web service in Azure Machine Learning Studio and then connect to it from Power BI. Here are the steps: 1. In Azure Machine Learning Studio, create a predictive experiment and publish it as a web service. 2. In Power BI, go to the "Get Data" menu and select "Azure". Then select "Azure Machine Learning Web Service". 3. Enter the URL and API key for the web service you created in Azure Machine Learning Studio. 4. Select the inputs and outputs for your Power BI report.

       

      Best Regards
      Community Support Team _ Rongtie

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.