Help with Dynamic Subscription Filters

[aallman]

Hello! Not sure if this is the right forum for this specific question but I need some help with setting up a subscription to one of my reports. 

The report is essentially a training tracker. The goal is that each associate gets a monthly email of their training status.

The way the report is built, each department has its own page built using its own set of data tables (pulled from their individual sharepoint lists). Only managers have access to the report online. We do NOT want associates to be able to see other associates' training data. How it works, the manager selects an associate's name from the visual filter on the page. This will "unhide" the data on the page and show the training data filtered to this associate. Each "Associate Name" column is in a separate data table for each of the departments.

I set up my dynamic subscription using a new data set that includes email, Associate Name (value to filter by), and report page. I linked all of these to the appropriate spots in the subscription set up. Maybe I don't understand how the "dynamic subscription" works but what happens is that I can't set up a list where the Associate Name is mapped to the different Associate Name columns from the different data tables. When I do that, the person gets the right page of the report sent to them, but the page is blank and no Associate Name is selected. If I only map the filter to one department's data table[Assosciate Name] then the subscription works great.

Will I have to set up separate subscriptions for each page and have different lists of people who need each page sent to them? Can it not be done in one subscription? I feel like it should be able to be done in one since I can map "Page" as a dynamic filter. Maybe I am just confused, any information would be greatly appreciated!!

[v-echaithra]

Hi @aallman ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[v-echaithra]

Hi @aallman ,

I hope the information provided is helpful.I wanted to check whether you were able to resolve the issue with the provided solutions.Please let us know if you need any further assistance.

Thank you.

[v-echaithra]

Hi @aallman ,

We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Thank you for your patience and look forward to hearing from you.

Best Regards,
Chaithra E.

[v-echaithra · Accepted solution]

Hi @aallman ,

Dynamic subscriptions in Power BI require a single, consistently defined field to apply filters. In your current setup, each department's report page is built on its own separate data table, each containing its own [Associate Name] column. Because these columns are not connected and exist in different tables, the subscription engine cannot determine which column to filter during report generation.

As a result, when the dynamic subscription runs, the filter fails to apply, leading to a blank report. This is expected behavior. Dynamic subscriptions do not support conditional logic or cross-table filtering when multiple unlinked columns are involved.
Inorder to ensure reliable delivery of filtered reports try this workaround:

Create a separate dynamic subscription for each department.

In each subscription map the dynamic filter (e.g., [Associate Name]) to the correct column for that department’s data table.

Ensure each subscription only references the report page tied to that department.

Use a contact list (email and associate name) specific to that department.

This approach ensures that each subscription uses a single, clearly defined filter column, which avoids ambiguity and guarantees accurate report rendering.

Hope this helps!
Warm Regards,
Chaithra E.