How to Implement Python code and Send Emails

[maessery]

I am currently working on a project that involves identifying certain customers and then alerting their dedicated sales reps individually. I am looking to automate this process with python. As of right now in order to achieve my goal, my process would be quite manual: 1) pull the data from our data warehouse with powerbi, 2) load the dataset into a jupyer notebook file, then 3) run my scripts. The problems with this approach are : 1) it is not automated, and 2) I am unable to effectively analyze my entire dataset due to the export size constraints in powerbi. Is there a way to integrate my python code into power bi so that i can automate the entire processs?

[Anonymous]

please share the solution 

[vanessafvg · Accepted solution]

have you thought of using power automate from power bi?

when you say its not automated, are you publishing this into the service?  I am not quite sure what you are struggling with, can you identify the issues you are having.  Power BI be can  be automated and you can run python scripts in power bi.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-python-scripts