Forum Discussion
Add Groups to report subscriptions on PPU?
Hi,
We currently have circa 100 users, these require PPU licenses due to the semantic model relying on XMLA connection.
Report subscriptions are a feature many teams find useful, receiving a report snapshot every morning in their inbox. However when people join and leave the company we have to manually update the recipient list.
IT said we have groups in Azure we could look at leveraging in BI, these groups come up in BI service, but I can't add them to the suibscriptions. Furthermore, this (https://learn.microsoft.com/en-au/power-bi/collaborate-share/end-user-subscribe?tabs=creator#subscribe-others) says 'Workspaces backed by a Premium Per User (PPU) license are different from those backed by a Premium capacity, and don't support subscribing group aliases.'
Two questions:
1, What is the most efficient way to manage subscriptions recipients? Azure groups are always up to date, but I was unable to use them in BI service.
2, What is the best way to share a snapshot of a report - screenshot of dashboard - to each store (+300)? These do not have a bi license.
Thanks,
Hello glearner ,
No need to create different paginated reports each time.
If the same report template is used for all 300 people, the rest is handled by dynamic subscription. The subscription will be executed 300 times with different parameters for each customer, for example (so the 300 executions will have the same template but with different data displayed).
You can also send to external users; there is a setting for this in the Fabric Admin section.Please feel free to give a kudo and validate the solution if it suits you.
Have a nice day,
Vivien
5 Replies
Hello glearner ,
In fact, what you want to do is not possible with your licensing level.
Have you tried data-driven subscriptions with Paginated Reports?
https://learn.microsoft.com/en-us/power-bi/collaborate-share/dynamic-subscriptionsThis allows you to store all the data related to your subscriptions in a DB/Table, and the subscription uses the data to send the information.
So if you have 300 users in your table, it will send it to all 300; if you have 250, it will send it to all 250...
All you have to do is keep this table up to date (automation is possible with an AD group content reader, for example).Another solution, with your current solution, would be to use a Power Automate flow to generate the subscriptions.
Please give me a kudo if my answer suits you 🙂
Have a nice day,
VivienHi vivien57
Thanks so much for your answer, I think it migth a good workaround; however it would mean that I need to create a specific paginated for each subscription I'm currently managing, right ? I wonder if its worthwhile.
Moreover, this wouldn't allow me to email a snapshot of the reports to external recipients would it ?
If the answers to the questions above are yes, then I'm afraid the best is to stick with Power Automate, as time consuming and clunky as it is. That's unfortunate.
Hello glearner ,
No need to create different paginated reports each time.
If the same report template is used for all 300 people, the rest is handled by dynamic subscription. The subscription will be executed 300 times with different parameters for each customer, for example (so the 300 executions will have the same template but with different data displayed).
You can also send to external users; there is a setting for this in the Fabric Admin section.Please feel free to give a kudo and validate the solution if it suits you.
Have a nice day,
Vivien
