Forum Discussion

mspowerbiuser's avatar
mspowerbiuser
Regular Visitor
4 years ago

Power BI Desktop (Power query-Azure Machine learning)- NEED HELP

Hi, 

NEED HELP!! 

 

I've trained, tested and deployed a classification task in azure machine learning studio using Automated ML. Seems like when am trying to make predictions on a similar data set as my training data set in power query by invoking the model in power query that was deployed in azure ml the input parameters don't show up as they show up for a regression task. Below attched are the screenshots of a classification task vs a regression task. Please let me know the best solution!! regression task - successfulclassification task - cannot see the columns as we see in the regression task

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi mspowerbiuser ,

    The input parameters for the AutoML model are automatically mapped as parameters of the corresponding Power Query function. Note that automatic mapping of parameters happens only if the name and data type of the parameter is the same.

     

    Please refer to the following document for  more details.

    https://docs.microsoft.com/power-bi/connect-data/service-tutorial-build-machine-learning-model#apply-the-model-to-a-dataflow-entity

     

    Best Regards

    Community Support Team _ Polly

     

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

     

     

     

  • mspowerbiuser's avatar
    mspowerbiuser
    Regular Visitor
    4 years ago

    Hi, Anonymous 

    Thank you for replying back. Although name and data type of the parameter is the same it doesn't seem to be working for a classification task. For the regression i see no issues. Please let me know if there is an alternative to get this working? 

     

    Thank you.

     

    • mspowerbiuser's avatar
      mspowerbiuser
      Regular Visitor
      4 years ago

      Hi, Anonymous 

      Thank you for replying back. Although name and data type of the parameter is the same it doesn't seem to be working for a classification task. For the regression i see no issues. Please let me know if there is an alternative to get this working? 

       

      Thank you.