Forum Discussion
Azure Auto ML and Power BI
Hi,
this is the latest relpy I have from MS on this. Tbh, I'm not what the Swagger things is for, but looks like an underlying bug that MS are now investigating.
*************
I’ve downloaded the same data from Kaggle and built a classification model with that. It looks like the input schema is not being generated for scoring purposes. Here’s the documentation for the scoring script and how it needs to be formatted for schema generation: https://docs.microsoft.com/en-us/azure/machine-learning/how-to-deploy-advanced-entry-script#automatically-generate-a-swagger-schema
About a month or so ago, the product team added a new parameter to the script to return the predicted probabilities for classification tasks. This ask came from customer feedback wanting to deploy a model and get the underlying probabilities, not just the label. As you see in the following picture, a parameter called “method” is in the JSON test script. I think versioning the classification model’s scoring script has affected the model consumption method with the form editor. I’ve raised the issue to the product team; they’re investigating now.
Meanwhile, I’ve built a regression model with the same data. On the AML test page, I can see the form editor now. When I connect this model with PBI, I can match the PBI dataset with the model attributes. The outputs are numeric, but you can set a threshold to convert the numeric results into categorical values. I believe that’s the quickest fix for now. I’ll keep you informed as soon as I hear an accurate answer/timeline to fix the bug for the classification models.
****************
Hi arifsyeduk1 ,
what you get from Auto ML (and see in your picture) are functions that will apply the determined ML logic to the current data.
So you have to import the data that you want the Azure ML logic applied to into your model as well.
Then apply the functions to them.
Hi,
sorry, I don't quite understand what you are saying or asking me to try. The model is deployed, I'm hoping that I can import a new data set in to PBI and apply the model to get the outcome as an additional column in PBI
Thanks
Hi arifsyeduk1 ,
trying to understand your request/estimation:
Where do you expect the new data set to come from (" ...I'm hoping that I can import a new data set in to PBI ...")?That is what I meant with "... So you have to import the data that you want the Azure ML logic applied to into your model as well. ... "
Hi,
I have a new data set (csv) that contains all the attributes/features that the Training data Set had that I used in Azure ML. The model has trained and been deployed. I now have imported a new data set in to PBI which does not have the 'outcome' column. This is fine and you can see that in my second screenshot. When I come to associate this data in PBI with the Model, one of the prompts as seen in the second screenshot is 'data'. This only allows me to select 1 column/feature. My question is what is PBI expecting in terms of data format so it can be passed in to the model row by row.
Would be happy to set up a MS Teams call to show the scenario.
Thanks
Hi,
I have a new data set (csv) that contains all the attributes/features that the Training data Set had that I used in Azure ML. The model has trained and been deployed. I now have imported a new data set in to PBI which does not have the 'outcome' column. This is fine and you can see that in my second screenshot. When I come to associate this data in PBI with the Model, one of the prompts as seen in the second screenshot is 'data'. This only allows me to select 1 column/feature. My question is what is PBI expecting in terms of data format so it can be passed in to the model row by row.
Would be happy to set up a MS Teams call to show the scenario.
Thanks
