How to integrate my own machine learning models in Power Bi ?

Question

Hello everyone,&nbsp;I would like to integrate machine learning into power Bi, and I have not found an answer to my problem in the power Bi help documents or on this forum.&nbsp;My problem is simple to understand but harder to code:&nbsp;I have an AI model already trained in python. I have saved it in pickle format but also deployed it in Azure Machine Learning.I would like to create a dashboard with user input (parameters) on one side of the dashboard. This data would be the inputs used to make the prediction with my Machine Learning model.&nbsp;However, I can't load my ML model in Power Bi. Azure gives a python script that allows you to consume the model, this script works very well under jupyter notebook but does not work under Power Bi.&nbsp;I don't know if what I'm trying to do is feasible, has anyone ever managed to integrate their Machine Learning model into power BI and make it predict live on the dashboards?&nbsp;Thank you in advance for your answers which will be of great help to me!&nbsp;Axel

greg_deckler · Answer

Anonymous&nbsp;In Power Query use the Azure Machine Learning option on the Home tab all the way to the right?

anonymous · Answer

Greg_Deckler&nbsp;Thank you very much for your reply !&nbsp;&nbsp;I already did it and as you can see I have my Machine Learning Model function on the left.&nbsp;The problem is, I don't know what is the good way to call this function on the inputs (power BI parameters) in order to make a prediction on those inputs.&nbsp;Do you have an idea ?&nbsp;

greg_deckler · Answer

Anonymous&nbsp;Hmm, this may or may not be a way since I think it is more for Direct Query models:
Dynamic M query parameters in Power BI Desktop (preview) - Power BI | Microsoft Docs
&nbsp;

v-xiaotang · Answer

Hi&nbsp;Anonymous&nbsp;
Did you try to enter parameter and hit Invoke button? Besides, I find a tutorial video, hope it helps.

https://www.youtube.com/watch?v=fqgQ3FV3Y34
&nbsp;
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

v-xiaotang · Answer

Hi&nbsp;Anonymous&nbsp;
Have you solved this problem? If yes, could you kindly accept the answer helpful as the solution (or kindly share your solution ). so the others can find it more quickly.really appreciate!Any question, please let me know. Looking forward to receiving your reply.
Best Regards,Community Support Team _Tang

Forum Discussion

How to integrate my own machine learning models in Power Bi ?

7 Replies

Related content

Machine Learning Prophet Issues

Migrating from Azure Machine Learning to Fabric

Getting Started with Machine Learning in Microsoft Fabric

Machine learning pipelines in Microsoft Fabric

Where is the Add Machine Learning Model