Forum Discussion
Dynamic subscription with multiple parameter value
Hi Phylicia,
Thank you Akash_Varuna for the solution you provided.I appreciate the detailed explanation of your scenario. The issue occurs because your dynamic subscription parameter table includes multiple rows for each user, which leads Power BI to send separate report emails for every row.
To address this, I suggest consolidating the countries for each user into a single row by concatenating the country values (for example, "US,CA"). This ensures each email address appears only once, and the @country parameter will return all relevant data in one report.
Here is an example of the aggregated table format:
Email | Country
[email protected] | US, CA
With this approach, you can use the new table for your dynamic subscription, and your existing CONTAINSSTRING(@country, Sales[Country]) logic will continue to function as intended.Thanks for reaching out! If this answer was helpful, please consider marking it as Accepted Solution and giving a Kudos, it helps the community!
Regards,
Sahasra.
Hi Phylicia,
Thank you Akash_Varuna for the solution you provided.
I appreciate the detailed explanation of your scenario. The issue occurs because your dynamic subscription parameter table includes multiple rows for each user, which leads Power BI to send separate report emails for every row.
To address this, I suggest consolidating the countries for each user into a single row by concatenating the country values (for example, "US,CA"). This ensures each email address appears only once, and the @country parameter will return all relevant data in one report.
Here is an example of the aggregated table format:
Email | Country
[email protected] | US, CA
With this approach, you can use the new table for your dynamic subscription, and your existing CONTAINSSTRING(@country, Sales[Country]) logic will continue to function as intended.
Thanks for reaching out! If this answer was helpful, please consider marking it as Accepted Solution and giving a Kudos, it helps the community!
Regards,
Sahasra.
Hi Phylicia,
We wanted to check if you had a chance to review our last reply. Let us know if it helped or if you need more guidance—we're always happy to help further.
If the solution worked for you, please click Accept as Solution and feel free to leave a Kudos for visibility.
Looking forward to hearing from you!
Thank you.
Hi Phylicia,
We wanted to follow up to see if our suggestion was helpful. Please let us know how things are progressing and if you are still encountering any issues.
If the response resolved your problem, you may mark it as the solution and give it a thumbs up to assist others in the community as well.
Thank you.
Hi Phylicia,
We strive to make sure every issue gets addressed completely. If the previous answer helped, that’s great, please mark it as Accepted and consider giving it a Kudos.
Still facing issues? Just reply here and we’ll be right with you.
Thank you for being a valued part of the community,