Help with Dynamic Subscription Filters

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.