Send email based on power bi dataset/dataflow

[darshaningale]

I have project related information like projectid , projectname, start date , end date.

I have manager related information for each project like manager name , manager email.

I want to send emails to manager based on  the project information.

Can you please guide ?

[v-jayw-msft]

Hi @darshaningale ,

You may take a look at the email subscription.

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-subscribe 

And the row level security.

https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls 

Best Regards,

Jay

[darshaningale]

I want to create a dataflow or dataset in power bi service and based on the data maybe create a power automate to send emails.

[v-jayw-msft]

Hi @darshaningale ,

Take a look at this document.

https://docs.microsoft.com/en-us/power-query/dataflows/send-notification-when-dataflow-refresh-compl... 

Best Regards,

Jay

[darshaningale]

I dont want to send notification. I want to send email based on the data.. The data will contain emails of the person to whoom the email is to be sent...sorry for not being clear earlier..