MS Automate emial list from PowerBI selection

[MarioBinas]

Hi,

I have received a task to combine MS Automate with list of emails generated by PowerBI dashboard. 

The task is to send email to all email addresses from the PowerBI report generated on daily base. 

As I am only getting in touch with MS Automate, I would appreciate a help from you guys. 

Thank you,

Mario

[Anonymous]

HI @MarioBinas,

If you mean to send an email report to users, you can consider using email subscription features:

Email subscriptions for Power BI reports and dashboards - Power BI | Microsoft Docs

If these email addresses are stored in the report dataset, you may need to extract them first, then you can use power automate to send report emails to that list.

Using Power Automate to run DAX queries against your Power BI dataset (datalineo.com)

Export and email a report with Power Automate - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng

[MarioBinas]

Hi @Anonymous 

thank you for your advice and tips. 

I have checked all the information, but my situation is a bit easier. 

I will be more specific about my task this time 🙂

I have a PowerBI report showing me on a daily base list of "suppliers" - email addresses -  with late deliveries. The idea is to use the Power Automate to send short notice email to the selected suppliers - not the report, just short notice "..... you are late with delivery....".

Thank you for any additional advice how to handle such a topic.

Mario

[Anonymous]

HI @MarioBinas,

Sure, you only need to change the second step(export power bi report) to use power automate to send an email with a specific template to specific users: (these user address lists are extracted by previous steps)

Customize email in flows with Power Automate - Power Automate | Microsoft Docs

Regards,

Xiaoxin Sheng