Script to Export Excel and send file or results to émail

[POWER_MI]

Hi, 

actualy i search some solution witch will be free to send email from power BI with excel file results to export

i will detail: 

the objectif is to define Kpi and progress on project. After having table it will have some Kpi green and some RED.

For the Red one they will be selected and sent to all people who work on this items i means

after selection the table export of red kpi will be :

Task                 pilote                email adresse 

action1          do action1           pilote1@gmail.com

action2          do action2           pilote2@gmail.com

action6          do action6           pilote1@gmail.com

....

and the aim is to send email from power bi to for example pilote1 : 

action1          do action1           pilote1@gmail.com

action6          do action6           pilote1@gmail.com

and for pilote 2

action2          do action2           pilote2@gmail.com

have you some script R/Python to do this without any paiement for microsoft

thanks for help

[V-pazhen-msft]

@POWER_MI 
Have you figured out or you found any workaround?

Paul

[POWER_MI]

Hi,

For the moment no solution because to do it it's mandatory to do scritp that we have not and also we have actualty just free version so very difficult.

thanks

[amitchandak]

@POWER_MI , refer if these can help

https://sqlitybi.com/how-to-auto-schedule-data-export-from-power-with-pythn/

https://owlcation.com/stem/How-to-Export-Data-from-Power-BI