cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

User Inputs values --> Database Captures Values --> ML Model Runs --> PBI Updates on ML output

Hi All,

I have a  requirement from a user.

1.  I have Customer data of XYZ firm. It is in MSSQL Database.

2.  I have Python code which will run on this data and provide some output like Similarity Score for the customer data.

 

Now the requirement is:

when a user opens Power BI Report he sees customer data. then we want user to input few fields(say we use PowerApps to get User Input and write to out database table). Input can be say similirity to be calculated based on customer location and total purchase amount..

So after customer selects location and purchase amount my ML Python code will select those columns as parameter and calculate similarity based on cutomer location and total purchase amount .

then Python writed data to Database table.

 

My Question is how do I get user inputs in power BI and pass those input vales to Python code.
As python will execute on run time as per selection of user input.

i was thinking of Domino as platform to host Python.

 

 

can anyone provide me with some woraroud or solution on this.
any inputs willl be highly appreciated.

0 REPLIES 0

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Top Solution Authors
Top Kudoed Authors
Users online (3,363)