Forum Discussion
Dynamic Email subscription
Found an article that suits the scenario im trying to do. Here is the link: https://eriksvensen.wordpress.com/2020/09/29/setup-data-driven-report-subscriptions-for-powerbi-paginated-reports-with-powerautomate/
Hi Anonymous ,
Dynamic subscription e-mail list, you can look into power automate. Unfortunately, I am not very familar with it , I suggest you open a thread in power automate forumn.
>>Also, the report details should only contains records that belongs to that team.
You can try to use dynamic rls . But for paginated and Power BI report email subscriptions, if the dataset uses row-level security (RLS), you can create subscriptions for yourself and others. Those subscriptions will run using your security context. so I suggest you publish another Power BI report that contains a hyperlink to the main Power BI report. then you can subscriber users to the report that contains the hyperlink, the users click on the link which takes them to the main Power BI report to which the RLS then applies.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai