Use a machine learning PREDICT function in a query

Microsoft Azure and Power BI offer powerful tools for designing and implementing enterprise-scale analytics solutions. One of the key features of this platform is the ability to utilize machine learning functions to predict outcomes in your data. In this article, we will explore how to use a machine learning PREDICT function in a query to enhance your analytics capabilities.

Getting Started

To get started, make sure you have a working knowledge of Azure and Power BI. You can refer to the Microsoft documentation for detailed guides on setting up your environment and understanding the basics.

Once you have your environment set up, you can begin using the PREDICT function in your queries. The PREDICT function allows you to apply a trained machine learning model to your data and generate predictions based on that model. To use this function, you’ll need a trained model stored in Azure Machine Learning, and the necessary permissions to access it.

Using the PREDICT Function

Here’s an example of how you can use the PREDICT function in a Power BI query:

let
Source = AzureMachineLearning.Tables(TableId),
Predict = PREDICT(Source, [OutputColumnName], [InputColumnName1], [InputColumnName2], [...]),
in
Predict

In this example, AzureMachineLearning.Tables(TableId) retrieves the table from Azure Machine Learning that contains the trained model. The PREDICT function is then used to generate predictions based on the specified input columns and the designated output column.

You’ll need to replace [OutputColumnName] with the name of the column where you want to store the predictions. Similarly, replace [InputColumnName1], [InputColumnName2], and so on with the names of the input columns that your model expects.

It’s important to note that the input columns must match the schema and data types expected by the trained model. Refer to the documentation for your specific machine learning model to determine the requirements.

Generating Predictions

Once you’ve written your query, you can refresh your Power BI report or dataset to execute the query and generate the predictions. These predictions can then be used to create visualizations and gain insights into your data.

Using the PREDICT function in Power BI allows you to leverage the power of machine learning and make informed decisions based on predictive analytics. With Azure and Power BI, you can seamlessly integrate machine learning capabilities into your analytics solution, providing valuable insights to drive business growth.

Conclusion

By using the machine learning PREDICT function in a query, you can enhance your analytics solutions in Azure and Power BI. This powerful feature enables you to leverage trained models and generate predictions based on your data. Make sure to refer to the Microsoft documentation for detailed instructions and examples specific to your setup and requirements. Start harnessing the power of machine learning to unlock valuable insights from your data today!