Dynamic Subscription for a power bi report with multiple recipients

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.

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.