Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ankit_talele
New Member

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors