Forum Discussion
Title: Dynamic subscription sends extra report emails when a link-only subscription is added.
Hi VishalSharma-71,
I think you're running into a side effect of sharing one recipient semantic model across multiple dynamic subscriptions. This behaviour is consistent, but seems really buggy to me nonetheless.
When any subscription runs, Power BI evaluates the recipient model you selected in that subscription and uses its columns to decide who gets an email, what the subject is, and whether to attach a PDF or send a link. The product docs show that behavior (email details, attachment selection, and the “Link to report in Power BI” toggle are all driven from the same recipient model), but they do not guarantee isolation by report if the same model feeds multiple subscriptions (docs, see “Email details” and “Considerations and limitations”). The same pattern exists for paginated reports (docs).
SOme options I would try:
- Give each report its own recipient table/view (or its own semantic model).
- Or, keep one model but partition it logically and hard-scope each subscription to a unique slice in the wizard’s Select and filter data step (not only in “Map your data,” and not only by turning dynamic filters on/off).
If you want to keep a single shared model, I recommend:
- Add a column like SubscriptionKey (e.g., ReportA, ReportB, ReportC) and filter on that in the subscription’s Select and filter data step.
- Avoid using a single row set where AttachmentType, EmailSubject, etc. differ across reports without also scoping by SubscriptionKey.
- Prefer a dedicated table or view per report inside the same model (e.g., Recipients_ReportA, Recipients_ReportB) so each subscription points at its own table in the Select and filter data step.
Answers to your specific questions
- Is this expected by design? There is no explicit doc stating runs are isolated by report when sharing a recipient model. Practically, evaluation is model-scoped for the subscription that runs, so rows not strictly filtered out can be picked up. So the behavior is explainable and avoidable, but not clearly documented as “by design.”
- Official guidance or docs? The docs cover how the recipient model drives recipients, subjects, and attachments and how the Link to report toggle works, but they do not describe cross-triggering behavior. See: Dynamic per recipient subscriptions for reports.
- Best practices to prevent cross-triggering (without splitting models):
- Add a SubscriptionKey column and filter to it in Select and filter data.
- Use distinct tables or views per report inside the same model and select the right table during setup.
- Keep attachment/link-only settings consistent within each key.
- Roadmap for link-only respecting schedules without touching other rows: Nothing public in docs at the moment. For tenant-specific confirmation, open a Microsoft support ticket and include your Cluster URI and recent Activity IDs from the email headers.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Hi tayloramy,
Thank you for the detailed explanation and the alternate solutions. I just need one clarification as my current recipient CSV file already includes the following columns IsLiveSubscription, Reportname, Frequency, Day, Time, DateRange, Location Name, IsToday, EmailSubject and Recipientemail. Each report name and it related details are already separated within this file.
However this issue occurs only when I configure the subscription to send only the link no attachment or PDF, all other dynamic subscription that send PDF attachments are working correctly. could you please share some insights on why this behavior happens only for link only subscription.
- d_m_LNK11 months ago
Super User
I totally agree with tayloramy -- if your CSV is used for multiple reports it is most likely the mapping you are using when you set up your subscription that is causing the issue. Not sure the difference between the PDF and the link options and why that would change but the root of the issue seems to be the shared CSV for mulitple subscriptions that opens you up to this happening and how you are mapping the emails and reports.
- tayloramy11 months ago
Super User
Hi VishalSharma-71,
I can't explain why it only happens with link subscriptions and not PDF subscriptions, just that this consistently happens with link subscriptions.
THere must be something in the backend causing this, and I assume that is a bug.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.