Report User Groups notification via E-Mail, challenge to inform each user that someting is new in th

[Stephan9999]

Hi at all,

i search for an solution.
I have a report with a lot of users. (singleuser,Usergroups)
Now i had some changes in the report. Now is the challenge to inform each user that someting is new in the report.

which kind solutions are possible?
or It´s possible to create a list of all users e-Mails automaticlly?

Thanks for your support

[anmolmalviya05]

Hi @Stephan9999, Hope you are doing good!
This is possible if you have a list of all the users and their mail id.
Using Power Automate

• Create a Flow: Set up a flow in Power Automate to send emails automatically. You can trigger this flow manually.
• Steps:
  1. Trigger: Choose a trigger (e.g., a new file upload or a change in a report).
  2. Action: Add an action to "Send an Email" and use your list of email addresses to specify the recipients.
  3. Dynamic Content: Customize the email content to inform users about the new updates.

Using Excel with VBA

• Excel Macro: If you prefer using Excel, you can create a macro to send emails.
• Steps:
  1. Prepare Data: Make sure your email addresses are in an Excel sheet.
  2. Write VBA Code: Write a VBA script to send emails to each address.

You can also refer to the blog post: (Check here)
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[Stephan9999]

Hello and thanks for the answer.
Yes, but now I would like to find a way to fill the email recipients automatically or from created a list. I have activated the report for about 400 users and keeping this large distribution list up to date is tedious.

Best Regards

[v-tianyich-msft]

Hi @Stephan9999 ,

You can subscribe your reports to your target users, which will be done in power bi service:

Email subscriptions for reports and dashboards in the Power BI service - Power BI | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Stephan9999]

Hello and thanks for the answer.
Yes, but now I would like to find a way to fill the email recipients automatically or from a list. I have activated the report for about 400 users and keeping this large distribution list up to date is tedious.

Best Regards