Forum Discussion
Help creating an AutoML (Machine Learning Model) on Power BI Apps
Hi All,
I'm working on the table below:
I'm trying to predict the values for the year 2022. However I'm not sure if the table should have been unpivotted first.
Also, when I apply the machine learning model I am confronted with the following options:
I am really not sure which options to select. I could be setting this model up the wrong way I am not entirely sure. Any help would be greatly appreciated.
Thank you,
Hi HamidBee ,
Sorry for misunderstanding your point. For understanding and learning regression models in machine learning, you can refer to the following blogs and documents that I hope will help you.
Building a Regression Model with zero code in Powe... - Microsoft Power BI Community
How to do Linear Regression in Power BI (iterationinsights.com)
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
HamidBee , I think you should unpivot first in power query
Okay, once I unpivot the data. What do I select for the outcome column and data to study fields?
Hi HamidBee ,
Based on your description, I think you can refer to the tutorial given in the official documentation below. Hope it will help you.
Tutorial: Build a Machine Learning model in Power BI
If the problem is still not resolved, please point it out. Looking forward to your feedback.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi v-henryk-mstf,
I honsetly used this tutorial when I first began. Unfortunately this tutorial wouldn't be entirely the same for me as I would be using a regression model. In this tutorial they show one how to use a binary model. So the way the data is set up wouldn't be the same. I've yet to see an example or explanation where someone is using a regression model here. Could you please provide a step by step guide on how I could use a regression model via AutoML?
Thank you
Hi HamidBee ,
Sorry for misunderstanding your point. For understanding and learning regression models in machine learning, you can refer to the following blogs and documents that I hope will help you.
Building a Regression Model with zero code in Powe... - Microsoft Power BI Community
How to do Linear Regression in Power BI (iterationinsights.com)
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
