Power BI Report Builder: Premium Per User and Premium necessary?

[Anonymous]

Hello all,

I have a customer that wants to distribute personalized reports for 100+ employees on a daily, weekly or monthly basis. The reports are to be sent via e-mail in a pdf format, showing the performance of each employee for a specified period of the time. All of this should preferably be done automatically.

1) Does my customer need to buy a Premium Workspace, or is it sufficient to go with a PPU and distribute the reports from there?

2) Is it possible to automatize the generation and distribution of 100+ personalized reports using PPU and Power BI Report Builder?

Kind regards,

J 

[v-cazheng-msft · Accepted solution]

Hi @Anonymous 

I think Premium Per User is sufficient to support customer needs.

• If the customer has Premium Per User license, he or she can also subscribe others to a subscription that includes the full report attachment. For more details, you can refer Full report attachment for subscriptions for Power BI Premium reports now available. But one thing to note is that PPU is currently out of Preview and it can be available like Pro. If the subscribers want to view the report or dashboard by the link, they will need Premium Per User license as well.
• For each report or dashboard, you can set up to 24 subscriptions and you can pass subscribers less than 200. If pass 200, you may encounter some delivery issue. Using group mail aliases instead can reduce the number. For Considerations of subscribing others, you can refer Subscribe others to your reports and dashboards in the Power BI service.
• As for the automation of subscriptions, Power Automate is indeed a good choice.

Subscribe to others including full report attachment with PPU:

Best Regards

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sumanth_23]

hi @Anonymous - You should be able to schdule and automate Power BI reports using Power Automate - please refer to the Microsoft documentation:

• Automate Power Report distribution - https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-automate-power-bi-report-export
• Automate Paginated Report distribution - https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-automate-paginated-integration

With regard to the licensing question - the Customer would have to buy a premium workspace as the reports that need to be distributed would need to be hosted on a Premium workspace for Power BI and Paginated reports. 

Hope this helps!