Dynamic Subscription for a power bi report with multiple recipients

[jnguyen21]

Is there a way to create a Dynamic Subscription for a power bi report with multiple recipients?

Right now this is my email list table that is sending out subscriptions. I have a separate subscription for Administrators and Managers. Instead of sending out 6 emails, I want to consolidate it so PBI only sends out 3 emails. Is there a way this can be done within the dynamic subscription?

Current

Location	Admin	Manager
Chicago	john@gmail.com	smith@gmail.com
Seattle	sam@gmail.com	steve@gmail.com
New York	tony@gmail.com	natasha@gmail.com

Proposed

Location	Email List
Chicago	john@gmail.com; smith@gmail.com
Seattle	sam@gmail.com; steve@gmail.com
New York	tony@gmail.com; natasha@gmail.com

[v-agajavelly]

Hi @jnguyen21 

Yes, this can be done by restructuring your data and leveraging the Dynamic Subscription (Per Recipient) feature in the Power BI Service (Premium workspace). Here's how to achieve your goal of sending one email per location with multiple recipients.

First Set Up Dynamic Subscription with Multiple Recipients per Location,

1. Restructure your email mapping table. Update your source table (used in the report) to the proposed format.

Location	Email List
Chicago	john@gmail.com; smith@gmail.com
Seattle	sam@gmail.com; steve@gmail.com
New York	tony@gmail.com; natasha@gmail.com

Use semicolon ; to separate multiple email addresses in the Email List column. This is the supported delimiter for Power BI email subscriptions.

2. Configure Your Power BI Report. Make sure your report has a slicer or parameter that filters based on Location, which will control what each recipient sees.
3. Publish Report to Power BI Service (Premium workspace required), dynamic subscriptions only work in Premium or PPU workspaces.
4. Create a Dynamic Subscription (Per Recipient)

• Go to the published report.
• Click on “Subscribe” > “Create dynamic per recipient subscription”.
• Select the email list column (e.g., Email List) as the recipient field.
• Select Location as the parameter or slicer field that filters the report.
• Power BI will now send one email per row, filtered by Location, and CC'd to all emails listed in that row.

Remember Emails must be separated by ; commas or line breaks won’t work. All emails must belong to Power BI licensed users in your tenant. If using RLS, make sure it’s applied correctly per Location.
look Instead of 6 separate emails, Power BI sends 3 emails (one per location). Each email goes to both Admin and Manager recipients together, filtered by that specific location’s data.

________________________________________________________________________________________________________________________

If this response helps, consider marking it as “Accept as solution” and giving a “kudos” to assist other community members.

Thank's,
Akhil.

[Deku]

You need to send 6. Unless you want to play with power automate