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

[Anonymous]

Hello everyone,

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.

My problem is simple to understand but harder to code:

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.

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.

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?

Thank you in advance for your answers which will be of great help to me!

Axel

[v-xiaotang]

Hi @Anonymous 

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

[Greg_Deckler]

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

[Anonymous]

@Greg_Deckler Thank you very much for your reply ! 

I already did it and as you can see I have my Machine Learning Model function on the left.

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.

Do you have an idea ?

[Lanchu]

Hi did you manage to make it predict live on the dashboards? if yes, can you share the solution please?

[v-xiaotang]

Hi @Anonymous 

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

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.

[Greg_Deckler]

@Anonymous 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